Can I disply Euro and Dollar Formats in the same spreadsheet

J

John Bomberger

I have a price list spreadsheet that shows euro and dollar pricing. In the
euro price cells, I want to disply euro format (€ 1,25). In the dollar price
cells, I want to display dollar format ($1.25). Is this possible and if so,
how?
 
P

Paul Sheppard

John said:
I have a price list spreadsheet that shows euro and dollar pricing. I
the
euro price cells, I want to disply euro format (€ 1,25). In th
dollar price
cells, I want to display dollar format ($1.25). Is this possible an
if so,
how?
Click to expand...

Hi John

The cells where you want Euros, format as euros, Format > Cells > Unde
Category select Currency > Under Symbol select Euro

Then for the cells where you want Dollars do the same but select
 
K

Ken Wright

Just select each range separately one at a time and then use Format / Cells
/ Currency, selecting the appropriate one in each case.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top