Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Enter "1", cell show ".01". Why?
Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct. What caused this and how can I fix it? |
#2
|
|||
|
|||
Try this ..
Click Tools Options Edit tab Uncheck "Fixed decimal" OK Things should be back to normal now .. (it's a fixed decimal setting !) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Yonian" wrote in message ... Any number typed into a cell is divided by 100. If proceded by "=" the number is correct. What caused this and how can I fix it? |
#3
|
|||
|
|||
If you format a cell as a date, and then you type 1 in the cell it will
display as 1 Jan 1900. Similarly, you have some format enabled that displays 1 as .01 Clear the formats in the affected cells, or format them as type number or General and you will have the entered numbers displaying correctly. To format, select the affected cells, right click and choose format Hope that helps "Yonian" wrote: Any number typed into a cell is divided by 100. If proceded by "=" the number is correct. What caused this and how can I fix it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
Some formula results will not show up in the cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |