In Microsoft Excel 2003,when i try to put the digit 3.68,it changes to 24800 or any other number.What should i do?Done everything........
2007-02-19 05:33:51 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
I think it may be reading it as a date 3.68 = March 1968, which is about 24800 days since 1st January 1900.
No idea why though. Try setting the number format in the cell to Number or General
2007-02-19 05:44:25 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Its a format Issue.
I tried running some format changes to see if I could replicate the change from 3.68 to 24800 , but nothing.
As near as I can figure a formula is being applied to that cell.
Just format it to what you want, or use formula painter to change the format from another cell to fix the problem cell
2007-02-19 13:37:39 · answer #2 · answered by Mictlan_KISS 6 · 0⤊ 0⤋
Make sure the cell formatting specifies number and two or more digits and there is no formula changing that value.
2007-02-19 13:38:28 · answer #3 · answered by BigRez 6 · 0⤊ 0⤋