| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel divides number by 10e6 unless followed by decimal point.
When I type a number into a cell Excel displays the number divided by
1,000,000 unless the number is followed by a decimal point. What can I do to change this? |
|
#2
|
|||
|
|||
|
"JohnO" wrote in message ... When I type a number into a cell Excel displays the number divided by 1,000,000 unless the number is followed by a decimal point. What can I do to change this? Format|Cells select number and number of decimals /Fredrik |
|
#3
|
|||
|
|||
|
Tools|options|Edit tab
uncheck that "fixed decimal places" box. JohnO wrote: When I type a number into a cell Excel displays the number divided by 1,000,000 unless the number is followed by a decimal point. What can I do to change this? -- Dave Peterson |
|
#4
|
|||
|
|||
|
This is not a question of simply formating the cell, and specifying the
number of decimal points. General, Text, Number (with zero points) cell formats all have the same result when a number is entered into the cell. "Fredrik Wahlgren" wrote: "JohnO" wrote in message ... When I type a number into a cell Excel displays the number divided by 1,000,000 unless the number is followed by a decimal point. What can I do to change this? Format|Cells select number and number of decimals /Fredrik |
|
#5
|
|||
|
|||
|
It worked. THANK YOU!!!
John O'Donnell =========================== "Dave Peterson" wrote: Tools|options|Edit tab uncheck that "fixed decimal places" box. JohnO wrote: When I type a number into a cell Excel displays the number divided by 1,000,000 unless the number is followed by a decimal point. What can I do to change this? -- Dave Peterson |
|
#6
|
|||
|
|||
|
John
ToolsOptionsEdit. Uncheck "Fixed Decimal Places". Gord Dibben Excel MVP On Mon, 21 Mar 2005 16:31:07 -0800, "JohnO" wrote: When I type a number into a cell Excel displays the number divided by 1,000,000 unless the number is followed by a decimal point. What can I do to change this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VARYING number of sheets in EXCEL | New Users to Excel | |||
| Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
