Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting numbers to date format
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting numbers to date format
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. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=162275 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting numbers to date format
On dec. 14, 13:22, "GC" wrote:
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! Try =DATEVALUE(B2 & "/" & A2 & "/" & C2) Regards, Stefi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting numbers from exponential 'E+' format | Excel Discussion (Misc queries) | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
converting telephone numbers to csv format! | Excel Discussion (Misc queries) | |||
Converting Numbers to Date Format | Excel Worksheet Functions | |||
Converting numbers to date format from csv files | Excel Discussion (Misc queries) |