![]() |
|
#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.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |