error in dates

[cheng]

Hi! I keep having problems when I type the date 6/16/86
in Excel, even if i format it, it won't display as a
date. Can anyone help me? Thanks.

 

[Frank Kabel]

Hi
check the format of your cell prior to entering the date. Probably the
cell format is set to 'Text'. change this to 'General' or a date format
and after this enter your date

 

[Peo Sjoblom]

If your regional setting is using dd/mm/yy it would be text,
see what happens if you type 16/6/86
If still incorrect what is it that you expect and what is it that you get

 

[Guest]

It worked!!! Thank you very much!!!

-----Original Message-----
If your regional setting is using dd/mm/yy it would be text,
see what happens if you type 16/6/86
If still incorrect what is it that you expect and what is it that you get

--

Regards,

Peo Sjoblom




.