how do i change 20050614 within in a cell to a recognised date

  • Thread starter Richard carpenter @ uniq
  • Start date
R

Richard carpenter @ uniq

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
 
D

daiblackburn

Hi Richard

try highlighting the column then
Data>text to columns>hit next until you reach the end and select the Date
option to read YMD

HTH

David

"Richard carpenter @ uniq" <Richard carpenter @
[email protected]> wrote in message
news:[email protected]...
 
Top