Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entered isn't number recorded in cell.
If you enter a "1" in the cell and hit Enter you get "0.00001" in the cell.
If you enter "1." you get "1" in the cell. Looked everywhere I could for some type of formating that was causing it and can't find anything. It happens with any spreadsheet that is run on one system we have. It doesn't matter where or when the spreadsheet was first created and you can put the spreadsheet on any other system and it is fine. Seems to be only one system that is affected. Any ideas what is going on? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entered isn't number recorded in cell.
<Tools <Options <Edit tab,
And *UNCHECK* "Fixed Decimals". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "BubbaGee" wrote in message ... If you enter a "1" in the cell and hit Enter you get "0.00001" in the cell. If you enter "1." you get "1" in the cell. Looked everywhere I could for some type of formating that was causing it and can't find anything. It happens with any spreadsheet that is run on one system we have. It doesn't matter where or when the spreadsheet was first created and you can put the spreadsheet on any other system and it is fine. Seems to be only one system that is affected. Any ideas what is going on? Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entered isn't number recorded in cell.
have a look at <tools<options<edit<fixed decimal<
regards -- Greetings from New Zealand "BubbaGee" wrote in message ... If you enter a "1" in the cell and hit Enter you get "0.00001" in the cell. If you enter "1." you get "1" in the cell. Looked everywhere I could for some type of formating that was causing it and can't find anything. It happens with any spreadsheet that is run on one system we have. It doesn't matter where or when the spreadsheet was first created and you can put the spreadsheet on any other system and it is fine. Seems to be only one system that is affected. Any ideas what is going on? Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entered isn't number recorded in cell.
check tools-options-edit
unselect fixed decimal places (Halfway down on left) "BubbaGee" wrote: If you enter a "1" in the cell and hit Enter you get "0.00001" in the cell. If you enter "1." you get "1" in the cell. Looked everywhere I could for some type of formating that was causing it and can't find anything. It happens with any spreadsheet that is run on one system we have. It doesn't matter where or when the spreadsheet was first created and you can put the spreadsheet on any other system and it is fine. Seems to be only one system that is affected. Any ideas what is going on? Thanks, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entered isn't number recorded in cell.
Thanks for the help.
-- BubbaGee "bj" wrote: check tools-options-edit unselect fixed decimal places (Halfway down on left) "BubbaGee" wrote: If you enter a "1" in the cell and hit Enter you get "0.00001" in the cell. If you enter "1." you get "1" in the cell. Looked everywhere I could for some type of formating that was causing it and can't find anything. It happens with any spreadsheet that is run on one system we have. It doesn't matter where or when the spreadsheet was first created and you can put the spreadsheet on any other system and it is fine. Seems to be only one system that is affected. Any ideas what is going on? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to tell if cell contains a FORMULA or user-entered number? | Excel Worksheet Functions | |||
Can excel give value in words of number entered in another cell? | Excel Worksheet Functions | |||
cell that only a certain number may be entered | Excel Worksheet Functions | |||
How to return a dollar value for a part number entered in a cell | Excel Worksheet Functions | |||
Entered text value equals a number I specify in another cell | Excel Worksheet Functions |