Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem: Excel divides all my entries
Hi All,
First my Excel 2003 was functioning perfectly, but now when I enter e.g. 1, Excel automatically divides it by 10 and shows 0.1. I'm aware that this is a cryptic descritpion, but it might be something someone is familiar with. Thanks! Sieto |
#2
|
|||
|
|||
Hi Sieto
try tools / options / edit and untick fixed decimal places if it is checked. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Sieto Verver" wrote in message ... Hi All, First my Excel 2003 was functioning perfectly, but now when I enter e.g. 1, Excel automatically divides it by 10 and shows 0.1. I'm aware that this is a cryptic descritpion, but it might be something someone is familiar with. Thanks! Sieto |
#3
|
|||
|
|||
Hi
Have a look at Tools/Options/Edit tab and Fixed decimals. -- Andy. "Sieto Verver" wrote in message ... Hi All, First my Excel 2003 was functioning perfectly, but now when I enter e.g. 1, Excel automatically divides it by 10 and shows 0.1. I'm aware that this is a cryptic descritpion, but it might be something someone is familiar with. Thanks! Sieto |
#4
|
|||
|
|||
Thanks! That did the trick!
Exciting function.... "Sieto Verver" wrote in message ... Hi All, First my Excel 2003 was functioning perfectly, but now when I enter e.g. 1, Excel automatically divides it by 10 and shows 0.1. I'm aware that this is a cryptic descritpion, but it might be something someone is familiar with. Thanks! Sieto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Excel and MSVDM (XP Powertoys) | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
Zip code sort is an Excel problem even when using the special cat. | Excel Discussion (Misc queries) | |||
Excel problem with web based spreadsheets | Excel Discussion (Misc queries) | |||
Staring Excel Problem | Excel Discussion (Misc queries) |