Can I disply Euro and Dollar Formats in the same spreadsheet

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

[Paul Sheppard]

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?

Hi John

The cells where you want Euros, format as euros, Format > Cells > Under 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 :-)
------------------------------*------------------------------*----------------



"John Bomberger" <John [email protected]> wrote in message
news:[email protected]...
>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?