Microsoft Office Forums Date format always interpreted as a formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2006, 10:32 AM
Butch Jackman Butch Jackman is offline
Novice
Date format always interpreted as a formula
 
Join Date: Oct 2005
Location: Mankato, Minnesota
Posts: 11
Butch Jackman
Default Date format always interpreted as a formula

When i enter 2/20/2006 into a date cell the program always wants to insert an '=' in front of it and try to calculate the division. I have tried different date formats including the custom dd/mm, pasting it from a spreadsheet that works The cell shows as locked but I have turned that off - no change. Any ideas?? They will be appreciated.
Reply With Quote
  #2  
Old 02-14-2006, 11:27 AM
Butch Jackman Butch Jackman is offline
Novice
Date format always interpreted as a formula
 
Join Date: Oct 2005
Location: Mankato, Minnesota
Posts: 11
Butch Jackman
Default

I discovered the problem. On the Tools>Options>trasnition tab there is a check off for "transition formula entry".

If this is checked, everything entered on a sheet is automatically interpreted as a mathmatic formula.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format always interpreted as a formula Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM
Date format always interpreted as a formula Stuck on this formula!!!! CADmanJP Excel 2 03-10-2006 02:06 AM
Date format always interpreted as a formula Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM


All times are GMT -7. The time now is 12:46 AM.


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