Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i change 20050614 within in a cell to a recognised date
the nomber is a download from a server, it's a date backwards i need it to
read as a normal date for a look up thanks richard |
#2
|
|||
|
|||
Hi Richard
try highlighting the column then Datatext to columnshit next until you reach the end and select the Date option to read YMD HTH David "Richard carpenter @ uniq" <Richard carpenter @ wrote in message ... the nomber is a download from a server, it's a date backwards i need it to read as a normal date for a look up thanks richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get cell to change colour when text is added to it to hi. | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
change a function in a workbook without changing every cell | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Change value in cell every n seconds | Excel Worksheet Functions |