try using this custom frmat: [h]:[m]

"Janet Kreinbrink" wrote:

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.