Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Excel 2003 "File Open": how keep folders at top with sort by Date. | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |