Date enters wrong #'s

  • Thread starter Frustrated_rich99
  • Start date
F

Frustrated_rich99

Hi,
I'm trying to format a cell to enter the date i.e. 6/12/06 dd/mm/yy
but when I format it custom dd/mm/yy it shows up as 11/03/40?

-Rich
 
R

Rookie 1st class

Is the cell already populated? I'm thinking yes. The current entry is not a
date, Try retyping after format. There is a date format like you want, no
need to custom format.
Lou
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Maniplation 1
How to enter a date in DD-MM-YYYY format 2
Date Format 10
Date Formats 4
Finding Date in an overseas format 21
Dlookup 7
Forcing a date entry format of dd/mm/yyyy 1

Top