Yen currency format 
Author Message
 Yen currency format

I can't find the Yen symbol in Excel currency format
choices.  I am running Excel XP under windows 2000

there are a large number of currency symbols from around
the world but no Yen??  I find this amazing.
the Yen symbol can be created with an Alt key sequence but
that turns numbers into labels.. I need a true Yen
currency formate

thanks



Fri, 15 Jul 2005 17:50:54 GMT  
 Yen currency format
Looks like you have to do a custom number format.  Currency format a cell
using, say, the $.  Then copy the yen ()symbol to the clipboard.  Finally
go into Format, Cells, Number, Custom and replace the $ with the .  You
might them copy that cell's format to the others that need it, or pick the
format from Format, Cells.

--
Jim Rech
Excel MVP



Fri, 15 Jul 2005 18:11:13 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Format cells, currency, symbols, yen

2. Yen currency symbol in excel XP

3. Currency field query that returns currency format?

4. Formatting currency table currency data

5. Currency Format versus Accounting Format

6. Its Urgent, how to Convert Currency format to Word Format

7. Format+Cells+Currency = Format+Cells+Number

8. How could I Convert Currency format to word format

9. Conditional Currency Formats & Number Formats within Formula

10. Yen Symbol


 
Powered by phpBB® Forum Software © phpBB Group