| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change numbers to date
how to change a column of numbers to a date like
2411 to 24/11/05 3011 to 30/11/05 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
change numbers to date
The formula is -
=value(left(a2,2)&"/"&right(a2,2)&"/2005") in a cell that has been formatted to dd/mm/yyyy Regards. Bill Ridgeway Computer Solutions "abe" wrote in message ... how to change a column of numbers to a date like 2411 to 24/11/05 3011 to 30/11/05 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
change numbers to date
That doesn't work for 1-digit days.
=DATE(2005,MOD(A1,100),INT(A1/100)) -- Kind regards, Niek Otten "Bill Ridgeway" wrote in message ... The formula is - =value(left(a2,2)&"/"&right(a2,2)&"/2005") in a cell that has been formatted to dd/mm/yyyy Regards. Bill Ridgeway Computer Solutions "abe" wrote in message ... how to change a column of numbers to a date like 2411 to 24/11/05 3011 to 30/11/05 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
change numbers to date
Hiya Abe,
Format Style Modify Date Then select the style you want Hope that helps :) -- @---}-- Laura..... :) Liverpool, England "Do you know where you're going to?" "abe" wrote in message ... how to change a column of numbers to a date like 2411 to 24/11/05 3011 to 30/11/05 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| How do I get Excel date to change from 1/1/1900? | Excel Worksheet Functions | |||
| change numbers to text | Excel Worksheet Functions | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Hybrid Mode
