I have a problem when trying to copy a military time from excel into another program. For instance I want to be able to copy a string of times.. 0100, 0200, 0300, etc. into another workbook. I tried using notepad and word but could not figure it out. Excel's formatting does not allow the use of 0's before any numbers. Ideas? Thanks
Time Formatting
in Macro Express and Macro Express Pro
Posted
I have a problem when trying to copy a military time from excel into another program. For instance I want to be able to copy a string of times.. 0100, 0200, 0300, etc. into another workbook. I tried using notepad and word but could not figure it out. Excel's formatting does not allow the use of 0's before any numbers. Ideas? Thanks