error in dates

  • Thread starter Thread starter cheng
  • Start date Start date
C

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.
 
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
 
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
 
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




.
Click to expand...
 
Back
Top