Re: Excel: = sign keeps coming up when i enter 7/1 for date
- From: "Norman Jones" <normanjones@xxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 Jun 2006 02:05:33 +0100
Hi Brandon,
I could only reproduce your problem if I inadvertently prefixed my entry
with an equals sign.
---
Regards,
Norman
"BrandonAma" <BrandonAma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:948FB6C6-9C59-478C-8B7A-78197DABF6DD@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: Delete all modules and forms from workbook
- Next by Date: Re: Resize Problem
- Previous by thread: Re: Delete all modules and forms from workbook
- Next by thread: Re: Excel: = sign keeps coming up when i enter 7/1 for date
- Index(es):
Loading