| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert e+ e- to number
How can I convert a number 1,234E+06 into 1234000 without having to rewrite
all the values in my dataset? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert e+ e- to number
Rightclick on the cell, click on format, and change it from scientific to
General, or Number. -- kassie never stop learning "Elisabeth" wrote in message ... How can I convert a number 1,234E+06 into 1234000 without having to rewrite all the values in my dataset? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert e+ e- to number
Try making your column wider.
-- Kevin Vaughn "Elisabeth" wrote: How can I convert a number 1,234E+06 into 1234000 without having to rewrite all the values in my dataset? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should have a formula to convert number into words | Excel Worksheet Functions | |||
| How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? | Excel Discussion (Misc queries) | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| "Convert to Number" option disappearing | Excel Discussion (Misc queries) | |||
Linear Mode
