| Home |
| Search |
| Today's Posts |
|
|
|
#1
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. |
| 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
