converting numbers to date format

G

GC

Hello,
I have 3 columns in a worksheet that contain a number that represents the
date and the other column has a number that represents the month and the
last is the year as a single digit. (A2=14, B2=12, C2=9) The 3 columns are
formated number with 0 decimal. I have a 4th column that is formated date.
(3/14/01). In this 4th column i have =B2 & "/" & A2 & "/" & C2. The result
is 14/12/9 and does not seem to be a date format. I suspect it is a string.
What do I have to do to convert this to date?

Cheers!
 
J

joel

Make sure the cell with the formula is set to a Date Format and not
general. It is is set to General you will get a number instead of a
date.
 
S

Stefi

Hello,
I have 3 columns in a worksheet that contain a number that represents the
date and the other column has a number that represents the month and the
last is the year as a single digit. (A2=14, B2=12, C2=9) The 3 columns are
formated number with 0 decimal. I have a 4th column that is formated date..
(3/14/01). In this 4th column i have  =B2 & "/" & A2 & "/" & C2. The result
is 14/12/9 and does not seem to be a date format. I suspect it is a string.
What do I have to do to convert this to date?

Cheers!
Click to expand...

Try
=DATEVALUE(B2 & "/" & A2 & "/" & C2)
Regards,
Stefi
 
G

GC

Thanks Stefi, that worked. Much appreciated.
Gerry

Hello,
I have 3 columns in a worksheet that contain a number that represents the
date and the other column has a number that represents the month and the
last is the year as a single digit. (A2=14, B2=12, C2=9) The 3 columns are
formated number with 0 decimal. I have a 4th column that is formated date.
(3/14/01). In this 4th column i have =B2 & "/" & A2 & "/" & C2. The result
is 14/12/9 and does not seem to be a date format. I suspect it is a
string.
What do I have to do to convert this to date?

Cheers!
Click to expand...

Try
=DATEVALUE(B2 & "/" & A2 & "/" & C2)
Regards,
Stefi
 

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

Excel does not accept text format! 0
Countdown macro - display settings 2
Remove numbers from brackets 0
Project Start and End Date is not consistent 1
Setting column width in a table with a macro is not working 0
How to count the numbers in a Word document? 0
Remove Identical words 0
Adding sequence numbers to paragraphs 0

Top