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! |
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) |