Date format

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Anyone know how to make excel recognise info as a date
when it is entered as 31.3.04

as opposed to 31/3/04 or 31-3-04?
 
Hi Peter
try formating the cells prior to entering values with the format
DD.MM.YY
 
You could convert it with a formula:

=SUBSTITUTE(A3,".","-")*1

Format as date.

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

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

copying_data_using_FillHandle 1
SUM Q 2
separating date and time 5
Sum value between two dates and copy to new cell 6
Problem formatting dates from CSV file 2
Sumproduct with Multiple Criteria 2
Lookup between two dates 3
Extracting a month name forom a date 5

Back
Top