![]() |
|
|
|
#1
|
|||
|
|||
|
Your problem is that Excel converts anything that vaguely looks like a date INTO a date. Simply change the number format of this column to Text and you should be OK. Your value is not really a number, it is text composed of alphanumeric characters which happen to be mostly digits - but this is not the sort of number used in calculations.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
AutoCorrect with Formatted Text
|
pmokover | Word | 16 | 10-30-2024 02:50 AM |
| Auto Date | klaws | Outlook | 0 | 08-24-2012 01:01 PM |
| date format | gsrikanth | Excel | 1 | 12-28-2011 05:06 AM |
| Import formatted text from Word into PowerPoint | parboy | PowerPoint | 0 | 07-06-2011 08:52 AM |
| Auto Update the date. | Nirik | Excel | 16 | 12-16-2010 04:23 AM |