| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 cells into 1 date?
I have inherited a spreadsheet that contains columns of numbers to represent
a day (dd), columns with numbers for month (mm) and another with the year (yyyy) How can I combine the 3 cells in a row to produce a date cell (dd/mm/yyyy)? e.g. A7 = 7 A8 = 5 A9 = 2001 but I need 07/05/2001 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a date from range, date is between dates in two other cells | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
| Sum Cells within each date. | Excel Worksheet Functions | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Threaded Mode
