Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Month & Year Text to Date Format - Help Please
Hi,
I need some help as i'm stuck... I have a cell which has the number 4 in it (meaning April). I also have another cell which has the number 2010 in it (as text as it is concatenated from having the 20 manually added to the mid of another number giving the 10 part). So basically cell A1 has the number 4 in it, Cell B1 has the number 2010 in it. How do I get these 2 together to give me a date format of 01/04/2010 in an Excel recognisable date format to use in a vlookup with another preformatted date cell? Any help greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Format date with just month and year | Excel Discussion (Misc queries) | |||
I need date format to be set up as month/year. | New Users to Excel | |||
day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions |