Excel number formatting question

[rob79]

Hi

I am taking a feed from a trading platform into an excel spreadsheet.
The figures that are coming in are in millions i.e. 136,805,014.62.
What i am trying to do is instead of the above number showing up, i would like that column to display this and the other numbers as 136.8
and a 56,123,456.0 to show as 56.1 (i.e. 56.1 million) i was looking under cells formatting using custom but it didn't seem to be working, is there a way to do it or would i be better off using a formula to convert the data?

thanks

 

[Richard Schollar]

Hi Rob

Are you using the following:

#,##0.0,,;-#,##0.0,,

This should do what you weant, as long as Excel is recognising these numbers as numbers and not as text.

Richard

 

[BJungheim]

Try:
[>99999]0.0,,"M";[>99]0.0,"K";#

 

[rob79]

sorted, thank you both very much