Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |