Formating

[Simmy1234]

Hi There

Please help, I need to format a list of my numbers to show in millions.

Regards
Simmy

 

[anandvarma]

Use paste special

 

[Yahya]

Hi Simmy
use format cells

 

[Simmy1234]

Hi Anandvarma

I'm not sure if some of your reply was cut out, All i see is use paste special

Do i need to type something and copy then paste special on top of all the numbers ?

Please forgive my in experience in excel.

Thanks

 

[Simmy1234]

Hi Yahya

Please forgive my inexperience, all i see is just try ....
I need to know the custom format to show numbers in millions.

Thanks

 

[anandvarma]

try this

first put 1000000 in one cell and copy this using control+C
then select range cell you want to convert to millions.
goto paste special dialog box and select divide
click ok

now you can clearly see all the selected the range is converted into millions

 

[Rick Rothstein]

Please help, I need to format a list of my numbers to show in millions.

An example of what you expect to see in the cell would have helped. Just guessing here... if you have 12345678, you would want to see 12.3M. To do that, Custom Format the cell using this pattern...

0.0,,"M"

Those commas are what are doing the main work.

 

[Yahya]

Simmy
if you want the 1000000 to look 1,000,000 use this format #,##
If you want the 1000000 to Look 1"M" use #,,"M" as Rick Rothstein suggestion

if you are looking for another format, write it here