Automaticly change currency format in cell [Closed]
2 Registration date
Tuesday October 16, 2018
Member Last seen
October 17, 2018
Oct 16, 2018 at 03:19 AM
- Latest reply:
2538 Registration date
Sunday September 12, 2010
Moderator Last seen
October 17, 2019
Oct 18, 2018 at 11:38 AM
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.
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
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?