LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kane
 
Posts: n/a
Default Excel enters date as a text format

Hi, I have Excel 2003 and have been working with 2000 for a while (hate that
new feature with error checking,etc.)

Anyways, I have a problem when trying to enter a date (ie. entering as
2/15/2005 or 2-15-2005) it's always entering it as a text format (ie.
'2/15/2005).

Well, this is leaving a problem with me because I can't change it to a
different date format now because it's recognizing it as a text instead of a
date.

I never had this problem with Excel 2000, I just entering the date and it
automatically enters it as a date. What the heck is going on with Excel 2003
(so far I'm not impressed that even a little thing as entering a date
Microsoft manages to complicate it)
 
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
Text not copying as text from Word to Excel 2003 Christine Excel Discussion (Misc queries) 4 March 3rd 05 11:33 PM
Date Format Question Josh O. Excel Discussion (Misc queries) 1 February 10th 05 09:45 PM
TEXT function to format a date in English & French IanC Excel Worksheet Functions 2 December 16th 04 01:59 PM
& reference answering as Date Serial # not actual text Kevin M Excel Worksheet Functions 0 November 30th 04 05:57 PM
How to write a "Text" or date custom format FBB Excel Worksheet Functions 1 November 28th 04 01:10 AM


All times are GMT +1. The time now is 11:22 PM.

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

About Us

"It's about Microsoft Excel"