Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2010, 07:09 AM
markg2 markg2 is offline A date question Windows 7 A date question Office 2007
Expert
A date question
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default A date question

Office XP

How can I put date information in a cell and tell Excel to leave the thing alone as the text I intended and not automatically convert the input to some sort of date equivalent? I've tried formatting the cell as text or as general or as ... and cannot stop Excel from changing the input to a date format.
Reply With Quote
  #2  
Old 10-03-2010, 12:05 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline A date question Windows XP A date question Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Put a single apostrophe (') in front of the date information.
Reply With Quote
  #3  
Old 10-03-2010, 02:55 PM
markg2 markg2 is offline A date question Windows 7 A date question Office 2007
Expert
A date question
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

Is there a way to format an entire column to ignore Excel's date default & date math?
Reply With Quote
  #4  
Old 11-05-2010, 02:35 PM
hannu hannu is offline A date question Windows 7 A date question Office 2007
Advanced Beginner
 
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default

Try seting the cells to text BEFORE you enter data. Text formatted cells seems to prevent many automatic conversions and formattings.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
A date question Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM
A date question Julian Date windseaker Excel 1 02-14-2010 01:44 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM
A date question Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:17 PM.


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