Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Becca C
 
Posts: n/a
Default How do I stop excel replacing numerical values with the date?

I have switched off the auto correct function on Excel, but it still replaces
numbers with any given date!! How do I solve this problem?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
format the cells as 'General' or as 'Number'

"Becca C" wrote:

I have switched off the auto correct function on Excel, but it still replaces
numbers with any given date!! How do I solve this problem?

  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

If plain numbers are being displayed as dates, change the format to
General (Cells/Format/Number).

XL's parser will, independently of autocorrect, always interpret a
string like x/y or x-y as a date if it can. To enter such strings
without being parsed, format the cell as Text before entering the
string, or precede the string with an apostrophe, e.g.:

'11-2

In article ,
"Becca C" <Becca wrote:

I have switched off the auto correct function on Excel, but it still replaces
numbers with any given date!! How do I solve this problem?

Reply
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
Excel converts Mapped drive to UNC - How to stop? Fred Links and Linking in Excel 1 January 20th 05 12:24 AM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 12:10 PM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM
Excel 2003 "File Open": how keep folders at top with sort by Date. Aging Analyst Excel Discussion (Misc queries) 1 December 3rd 04 03:26 AM
Creating a Date Selector in Excel VBA? Mark Excel Discussion (Misc queries) 0 November 25th 04 10:59 PM


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