Thread: Format dates from cvf file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Janet Kreinbrink Janet Kreinbrink is offline
external usenet poster
  
Posts: 1
Default Format dates from cvf file
Hi,
I have a large spreadsheet of data from a cvf file. Column B has the time
in this format: 1700. Can't for the life of me figure out how to chage it to
miliary time (17:00).

Thanks.
Reply With QuoteReply With Quote