Can I disply Euro and Dollar Formats in the same spreadsheet

[Guest]

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?

 

[Paul Sheppard]

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?

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

 

[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
------------------------------­------------------------------­----------------