LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Watts
 
Posts: n/a
Default How do I prevent Excel from auto-correcting the date format?

I am using Excel, and every time I enter 2/1 in the spreadsheet - it corrects
it to Feb-1. How do I prevent it from doing this?
 
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
How to auto arrange the worksheet in a excel 2002 file? Balaji's Excel Worksheet Functions 1 May 13th 05 03:06 PM
How do I auto increment cell value on print in Excel Hiren Excel Worksheet Functions 7 January 25th 05 06:39 PM
How can I stop Excel from correcting data in a sp.sheetfor instan. AaronMahl Excel Discussion (Misc queries) 1 December 28th 04 06:30 PM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM
auto save in office excel 2003 Monsieur_Rick Excel Discussion (Misc queries) 2 November 30th 04 11:17 PM


All times are GMT +1. The time now is 05:10 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"