FlyerTalk Forums - View Single Post - Foreign currency format in Excel cells

Sep 19, 2006 | 3:59 pm

#8

KenJohn

Join Date: Apr 2005

Location: LHR

Programs: BA Gold, TG Gold, HHonors Diamond, SPG Plat

Posts: 8,665

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|

Reply