more date conversions

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi Neville,

not sure if this is part of a continuing conversation, but as you don't
mention one in your post i'll assume you simply have a cell with the number
10000104 entered and you want to convert it to a date. If so, this can be
done by placing the following formula in an adjacent cell
=DATE(2000,MID(A1,4,2),RIGHT(A1,2))
where A1 is the reference of your number.
you can then copy & edit / paste special - values the result of this over
the original data if required

Cheers
JulieD
 
now i have a date entered as 1000104 which I want as to be 04/01/2000, any
suggestions? thanks.
 
Sorry for the previous re: I hadn't looked at your previous posts. Jennifer
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
Text to Date 8
Special converting of string date&time to date format 3
Special string convertion to date and time 4
Imported dates have month first. 2
counting dates using SUMPRODUCT 4
Date(Year,Month,Day) not returnign correct date 6
conversion chart 4

Back
Top