View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FishandChips FishandChips is offline
external usenet poster
 
Posts: 1
Default converting numbers to time

I have a list of numbers:

900
1030
830 etc.

I need these in the format:

09:00:00
10:30:00
08:30:00 etc

I have tried text to columns but without the 0 before 830 the fixed width
line doesnt fall right.

Very stuck on this so any help would be gratefully recieved (otherwise I
have alot of work on my hands!!)