| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coverting numbers to decimal
How do I convert 5000000 on a spread sheet to 5.0 without having to divide by
1000000. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coverting numbers to decimal
Found the answer on a previous post. Thanks #.00,,
"Newbee" wrote: How do I convert 5000000 on a spread sheet to 5.0 without having to divide by 1000000. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coverting numbers to decimal
That does not "convert" the value.
Just displays the same value differently. Hope you're not relying on 5.0 when adding up your phone bill. Gord Dibben MS Excel MVP On Mon, 29 Sep 2008 16:08:32 -0700, Newbee wrote: Found the answer on a previous post. Thanks #.00,, "Newbee" wrote: How do I convert 5000000 on a spread sheet to 5.0 without having to divide by 1000000. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coverting numbers to decimal
Right click the cell
Format Cell Number Tab Custom - Add the following 0.0,, -- HTH... Jim Thomlinson "Newbee" wrote: How do I convert 5000000 on a spread sheet to 5.0 without having to divide by 1000000. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coverting numbers to decimal
Hi,
As Gord said this does not convert the 5000000 to 5 it just changes the display. If you want to convert a lot of number in the same way: 1 Enter 1000000 in an empty cell 2. Copy the cell 3. Highlight all the cells you want to convert and choose Edit, Paste Special, Divide -- Thanks, Shane Devenshire "Newbee" wrote: How do I convert 5000000 on a spread sheet to 5.0 without having to divide by 1000000. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| coverting numbers format | Excel Discussion (Misc queries) | |||
| coverting h:mm to decimal | Excel Discussion (Misc queries) | |||
| Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| How can I sort mostly 3 decimal with some 4 decimal numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
