Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel only writes 0,0001 instead of 0,1
My Excel 2000 seems to have a problem. I can no longer write a normal "1"
without correcting it manualy. Interestingly the problem is only with the "1" no other number is affected. When I wrtite "0,1" the programm writes "0,0001" and if just type in a single "1", it writes "0001" - Who can help? Thx in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel only writes 0,0001 instead of 0,1
Check and remove any custom formats.. Format|Cells|Number--Custom format...
-- If this post helps click Yes --------------- Jacob Skaria "Florian" wrote: My Excel 2000 seems to have a problem. I can no longer write a normal "1" without correcting it manualy. Interestingly the problem is only with the "1" no other number is affected. When I wrtite "0,1" the programm writes "0,0001" and if just type in a single "1", it writes "0001" - Who can help? Thx in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel only writes 0,0001 instead of 0,1
Firstly thx for the quick reply:
Secondly: No that also was my first thought, but the problem is as follows: 1. it only happens with the "1" any other numbers are ok 2. it also happens if I wirte only text like: "Today is the 1.5." then he writes "Today is the 0001.5.", so always when I type a "1" the program types "0001" 3. the problem is on every sheet, even new ones. -- my only solution is to change it always manually after the program changed it, and that cannot be right. Please help! "Jacob Skaria" wrote: Check and remove any custom formats.. Format|Cells|Number--Custom format... -- If this post helps click Yes --------------- Jacob Skaria "Florian" wrote: My Excel 2000 seems to have a problem. I can no longer write a normal "1" without correcting it manualy. Interestingly the problem is only with the "1" no other number is affected. When I wrtite "0,1" the programm writes "0,0001" and if just type in a single "1", it writes "0001" - Who can help? Thx in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel only writes 0,0001 instead of 0,1
Check Tools--Autocorrect Options...and remove 1 from the list
-- If this post helps click Yes --------------- Jacob Skaria "Florian" wrote: Firstly thx for the quick reply: Secondly: No that also was my first thought, but the problem is as follows: 1. it only happens with the "1" any other numbers are ok 2. it also happens if I wirte only text like: "Today is the 1.5." then he writes "Today is the 0001.5.", so always when I type a "1" the program types "0001" 3. the problem is on every sheet, even new ones. -- my only solution is to change it always manually after the program changed it, and that cannot be right. Please help! "Jacob Skaria" wrote: Check and remove any custom formats.. Format|Cells|Number--Custom format... -- If this post helps click Yes --------------- Jacob Skaria "Florian" wrote: My Excel 2000 seems to have a problem. I can no longer write a normal "1" without correcting it manualy. Interestingly the problem is only with the "1" no other number is affected. When I wrtite "0,1" the programm writes "0,0001" and if just type in a single "1", it writes "0001" - Who can help? Thx in advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel only writes 0,0001 instead of 0,1
Thanks a lot great help!!!
It worked.....again something learned! "Jacob Skaria" wrote: Check Tools--Autocorrect Options...and remove 1 from the list -- If this post helps click Yes --------------- Jacob Skaria "Florian" wrote: Firstly thx for the quick reply: Secondly: No that also was my first thought, but the problem is as follows: 1. it only happens with the "1" any other numbers are ok 2. it also happens if I wirte only text like: "Today is the 1.5." then he writes "Today is the 0001.5.", so always when I type a "1" the program types "0001" 3. the problem is on every sheet, even new ones. -- my only solution is to change it always manually after the program changed it, and that cannot be right. Please help! "Jacob Skaria" wrote: Check and remove any custom formats.. Format|Cells|Number--Custom format... -- If this post helps click Yes --------------- Jacob Skaria "Florian" wrote: My Excel 2000 seems to have a problem. I can no longer write a normal "1" without correcting it manualy. Interestingly the problem is only with the "1" no other number is affected. When I wrtite "0,1" the programm writes "0,0001" and if just type in a single "1", it writes "0001" - Who can help? Thx in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date issue-displaying as 0001-01-01 | Excel Discussion (Misc queries) | |||
Excel writes a formula on it's own - ?? | Excel Discussion (Misc queries) | |||
Number format need to display 0001 etc | Excel Discussion (Misc queries) | |||
Excel writes "May 10" when I input "5-10". How to stop this? | Excel Discussion (Misc queries) | |||
Excel re-writes working links and breaks them help! | Links and Linking in Excel |