Thread: Text to date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pimamedic Pimamedic is offline
external usenet poster
 
Posts: 64
Default Text to date

TY TY TY

Now how do I convert 240 to time format which in this case woudl be 3 hours

"Mike H" wrote:

hi,

And Another

select the date(s) in a column then

Data|Text to columns - Next - Next - Select Date - YMD

Finish

Mike

"Pimamedic" wrote:

How do I convert 20090228 to read as 02/28/2009 is there a format to do
this?? TY