FlyerTalk Forums - View Single Post - Foreign currency format in Excel cells
Thread: Foreign currency format in Excel cells
View Single Post
Old Sep 20, 2006 | 2:16 am
  #10  
Tennisbum
 
Join Date: Sep 2004
Location: Deep in the heart of...DL country.
Programs: DL GM
Posts: 3,838
Originally Posted by KenJohn
Choose
Format
Cell
Custom

From the menu, select 0,000.00;-0,000.00
In the space where this appears at the top of the list, literally, highlight the "." and just type in ",".
This should now appear as 0,000,00;-0,000,00

You can put in anything you want:
, or a or ~ or|
When I do that "1,892.83" displays as "1,893".
Tennisbum is offline  
Reply