How to change millions view in Exce

March 16, 2009 at 05:51:40
Specs: Windows XP
How can I change £15,479,563 in excel to show as £15.480?

Any help would be great.
Thanks very much


See More: How to change millions view in Exce

Report •


#1
March 16, 2009 at 06:42:37
With £15,479,563 in A1:

=A1/1000000 formatted to show 3 decimal places.

Directly:

=15479563/1000000 formatted as currency with 3 decimal places.


Report •

#2
March 16, 2009 at 09:33:24
or go to format cells and use the custom format

#"."###,

remember the trailing comma!

Also please note this may be different depending on your regional settings


Report •

#3
March 16, 2009 at 09:49:06
And don't forget to add the currency symbol in the custom format:

[$£-809]#"."###,


Report •

Related Solutions


Ask Question