| 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 | |||
Hybrid Mode
