View Single Post
 
Old 09-06-2013, 02:38 AM
C J Squibb C J Squibb is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Aug 2013
Location: Essex
Posts: 14
C J Squibb is on a distinguished road
Default

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.
Reply With Quote