Can I disply Euro and Dollar Formats in the same spreadsheet
 

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?

John Bomberger Wrote:
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 $


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397119

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 wrote in message
...
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?