Thread: I need to add space to convert DATE to TIME format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default I need to add space to convert DATE to TIME format
custom format B2 as

'mm/dd/yyyy hh:mm AM/PM' (no quotation marks)

HTH

"Wannano" wrote:

A2: 4/03 6:36pm
B2: FORMULA HERE

In B2, I need to convert A2 to 4/3/07 6:36 pm - putting a space between the
time and PM.

Thanks!

--
Texas Wannano
Reply With QuoteReply With Quote