| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Auto entry of "=" before dates
I have a WS that automatically adds an "=" to every cell when dates are
entered. When the cell format is changed to a date format, the result is always 1/0/1900. If I create a date in a new WS, I can cut and copy the cell into the other WS and it works properly, that is, the "=" is not added. Why is the "=" added at all? |
|
#2
|
|||
|
|||
|
Go to Tools/Options/Transition, and be sure Transition formula entry is NOT
checked. On Thu, 27 Jan 2005 14:39:05 -0800, "lg" wrote: I have a WS that automatically adds an "=" to every cell when dates are entered. When the cell format is changed to a date format, the result is always 1/0/1900. If I create a date in a new WS, I can cut and copy the cell into the other WS and it works properly, that is, the "=" is not added. Why is the "=" added at all? |
|
#3
|
|||
|
|||
|
Thanks Myrna!
"Myrna Larson" wrote: Go to Tools/Options/Transition, and be sure Transition formula entry is NOT checked. On Thu, 27 Jan 2005 14:39:05 -0800, "lg" wrote: I have a WS that automatically adds an "=" to every cell when dates are entered. When the cell format is changed to a date format, the result is always 1/0/1900. If I create a date in a new WS, I can cut and copy the cell into the other WS and it works properly, that is, the "=" is not added. Why is the "=" added at all? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
| auto entry of a date | Excel Worksheet Functions | |||
| Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Hybrid Mode
