Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel: = sign keeps coming up when i enter 7/1 for date
There is a bug in my file. When i enter "7/1" for a date of July 2006, i get
"7" instead. Looking at the formula bar shows "=7/1". When i go to format the cell to date, i get "January 1900". It seems to be happening to 4 of 9 sheets in the work book and in all cells. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel: = sign keeps coming up when i enter 7/1 for date
Hi Brandon,
I could only reproduce your problem if I inadvertently prefixed my entry with an equals sign. --- Regards, Norman "BrandonAma" wrote in message ... There is a bug in my file. When i enter "7/1" for a date of July 2006, i get "7" instead. Looking at the formula bar shows "=7/1". When i go to format the cell to date, i get "January 1900". It seems to be happening to 4 of 9 sheets in the work book and in all cells. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel: = sign keeps coming up when i enter 7/1 for date
Try:
tools|options|Transition tab|uncheck Transition Formula Entry (I'd turn off all those options.) BrandonAma wrote: There is a bug in my file. When i enter "7/1" for a date of July 2006, i get "7" instead. Looking at the formula bar shows "=7/1". When i go to format the cell to date, i get "January 1900". It seems to be happening to 4 of 9 sheets in the work book and in all cells. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My date is coming up 0-Jan-00 when I type current date. Why? | Excel Discussion (Misc queries) | |||
Enter sign replace in Excel 2007 | Excel Discussion (Misc queries) | |||
why is the date coming up as a | Excel Discussion (Misc queries) | |||
How do i enter the date in column instead of # sign? | Excel Worksheet Functions | |||
Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions |