Represent data in Million using 'format cells option'

[ramprasadmg]

Hi
I have a set of numbers (value, let us say in Millions) which I would like to represent in x.xx format.

One easy method is to divide the number by Million and present it. But I am looking for a solution where it is done using Format Cells.

Can somebody help? Thanks in advance.

Regards
Ram

 

[vletm]

... so close or sometimes have to use formats like 0.00,, or 0.00,,

 

[ramprasadmg]

Thanks, Vletm.

Appreciate your help.

 

[JCTalk]

I put something like this into a workbook I did recently. If you use square brackets, you can combine different formats. In mine I've got "M" for anything over a million, and "K" for anything over a thousand.

If you want it I'll share it tomorrow.

 

[ramprasadmg]

Hi JCTalk,
Please do share. Thanks in advance.

Ram

 

[JCTalk]

Hi Ramprasadmg,

Here is the custom format I use to produce "M" and "K".

[>=1000000]_-£* #,##0.00,," m"_-;[>=1]_-£* #,##0.00," k"_-;_-£* "-"??_-;_-@_-

Hope that helps in some way.

 

[ramprasadmg]

Hi JCTalk - thanks a lot. This is awesome.

 

[JCTalk]

You are welcome. It's nice to be able to give something back.