Formatting 1000's

A

Alan

I want to format as follows.

I have the number 1,522.32.
I want to format and see 1,5

How can I do this without modelling and dividing by 1,000. I want to format.

Any help would be appreaciate.
Thanks
 
F

Frank Kabel

Hi Alan
I used
#,##0.0,
(removed one zero after the decimal pont) and this returns 1.5 for me
 
B

BrianB

Use custom format something like :-
#,##0,;[Red](#,##0,);-;
ie. put an additional comma
 
D

David McRitchie

Or something along these lines a little bit easier to read
0.0,"K"_);(0.0,"K)";0"K"_);@
so that 1,100 is shown as 1.1K

0.0,,"M"_);(0.0,"M)";0.0"M"_);@
so that 1,100,000 is shown as 1.1M

Which may cause more confusion because K is used
interchangeably for 1,000 and 1024 and M was used
for thousands as in Roman numerals or for millions by others.
 
C

Curtis T

Alan,

Did you find a format that works? I am facing the same dilemma and would like to know how you resolved it

Thanks

Curtis
Los Angeles, CA
 
D

David McRitchie

correction on the second formula left out the second
comma on the negative value -- it is correct on my
formula.htm page though for what's it worth.
0.0,,"M"_);(0.0,,"M)";0.0"M"_);@
 
Top