LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date issue-displaying as 0001-01-01 Tasha Excel Discussion (Misc queries) 5 November 13th 08 10:19 PM
Excel writes a formula on it's own - ?? slreilly Excel Discussion (Misc queries) 5 August 4th 07 06:12 PM
Number format need to display 0001 etc Carys Excel Discussion (Misc queries) 4 July 27th 06 07:22 PM
Excel writes "May 10" when I input "5-10". How to stop this? Carter Excel Discussion (Misc queries) 2 August 5th 05 06:52 PM
Excel re-writes working links and breaks them help! ihatespam Links and Linking in Excel 1 June 22nd 05 11:43 PM


All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"