Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2013, 02:38 AM
C J Squibb C J Squibb is offline Text auto formatted as date format Windows 7 64bit Text auto formatted as date format 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text auto formatted as date format 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft