Excel number formatting question

rob79

New Member
Joined
Oct 13, 2006
Messages
5
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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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
 

Forum statistics

Threads
1,141,758
Messages
5,708,358
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top