Automaticly change currency format in cell
Closed
Dielux
TrowaD
- Posts
- 2
- Registration date
- Tuesday October 16, 2018
- Status
- Member
- Last seen
- October 17, 2018
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Change the format of the highlighted cells to currency
- Change the format of the selected cell to the mm/dd/yyyy - Guide
- Conditional formatting change font color based on another cell ✓ - Forum - Excel
- Conditional formatting highlight cell if another cell contains text ✓ - Forum - Excel
- Change color to different cells based on another cells text. ✓ - Forum - Excel
- Why can't i change the format of a cell in excel ✓ - Forum - Excel
3 replies
TrowaD
Oct 16, 2018 at 11:29 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 16, 2018 at 11:29 AM
Hi Dielux,
You can do it both ways.
Select the columns you want to format. Hit Ctrl+1 and select the currency you want.
Select 1 cell, hit Ctrl+1 and select the currency you want. Copy that cell and select the other cell. Right-click and select "paste special" and choose format only.
Best regards,
Trowa
You can do it both ways.
Select the columns you want to format. Hit Ctrl+1 and select the currency you want.
Select 1 cell, hit Ctrl+1 and select the currency you want. Copy that cell and select the other cell. Right-click and select "paste special" and choose format only.
Best regards,
Trowa
Dielux
Oct 17, 2018 at 01:35 AM
- Posts
- 2
- Registration date
- Tuesday October 16, 2018
- Status
- Member
- Last seen
- October 17, 2018
Oct 17, 2018 at 01:35 AM
Not what I was looking for, what im trying to do is
put € or $ or £ or ..., in one cell, and have it automatically change the currency format in selected cells and columns.
Or, format the currency in 1 cell, and have it automatically change the currency format in selected cells and columns.
Not sure if that is even possible, but it would really come in handy
put € or $ or £ or ..., in one cell, and have it automatically change the currency format in selected cells and columns.
Or, format the currency in 1 cell, and have it automatically change the currency format in selected cells and columns.
Not sure if that is even possible, but it would really come in handy
TrowaD
Oct 18, 2018 at 11:38 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 18, 2018 at 11:38 AM
Hi Dielux,
Sorry, but I don't understand your request.
You want to format a cell and have that same format applied to selected cells and columns. But when you already selected those cell and columns, the format will also be applied to those cells.
So, for example, you want the format applied to A1 automatically be applied to B10, E5 and column G. Then Select A1, B10, E5 and column G, apply format and you are done.
Am I misunderstanding?
Best regards,
Trowa
Sorry, but I don't understand your request.
You want to format a cell and have that same format applied to selected cells and columns. But when you already selected those cell and columns, the format will also be applied to those cells.
So, for example, you want the format applied to A1 automatically be applied to B10, E5 and column G. Then Select A1, B10, E5 and column G, apply format and you are done.
Am I misunderstanding?
Best regards,
Trowa