Automaticly change currency format in cell

Closed
Dielux
Posts
2
Registration date
Tuesday October 16, 2018
Status
Member
Last seen
October 17, 2018
- Oct 16, 2018 at 03:19 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Oct 18, 2018 at 11:38 AM
Hello,

I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually make sure I change the currency in my pricing column every time.

To make this easier, I am trying to find a way, so fill in 1 cell, and make it change the currency format in certain columns.

Another option would be to format 1 cell, and copy the layout of that cell automatically to other cells. Is this even possible ?

thx in advance.

3 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
0
Dielux
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
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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

0