A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

dates and numbers



 
 
Thread Tools Display Modes
  #1  
Old September 12th, 2004, 11:30 PM
external usenet poster
 
Posts: n/a
Default dates and numbers

hi there, every time i type in a number in an excel cell,
it is automatically converted into a date. i turned off
auto complete, tried format, cell, number, but nothing
works. any ideas and suggestions? it would be greatly
appreciated.
  #2  
Old September 13th, 2004, 12:42 AM
Myrna Larson
external usenet poster
 
Posts: n/a
Default

What, exactly, are you typing? If it looks like a date, say it has slashes or
dashes, Excel tries to interpret it as a date. What happens if you clear the
formatting for these cells AFTER you've entered the data?

On Sun, 12 Sep 2004 15:30:15 -0700,
wrote:

hi there, every time i type in a number in an excel cell,
it is automatically converted into a date. i turned off
auto complete, tried format, cell, number, but nothing
works. any ideas and suggestions? it would be greatly
appreciated.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbers and dates not printing on reports Mary Running & Setting Up Queries 1 September 2nd, 2004 10:31 PM
Averaging dates, doesn't see them all as numbers Kevin M Worksheet Functions 1 August 20th, 2004 05:45 PM
text numbers as dates via OCR import Dave Peterson General Discussion 1 August 20th, 2004 01:57 PM
Calculating days between two dates and multiply them with different numbers [email protected] Worksheet Functions 3 June 1st, 2004 06:36 PM
prevent Excel from EVERautomatically converting numbers to dates gt Worksheet Functions 1 December 9th, 2003 11:01 PM


All times are GMT +1. The time now is 10:42 AM.


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