Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Dagfish

    Leading zeroes in times (Excel/csv)

    Thanks guys - I sorted it by saving the CSV file, then formatting the appropriate column in the CSV file to hh:mm and ensuring that this new format was also saved. The altered bit of code can be seen below. The file can then be opened successfully in Notepad. Do Until Counter > File_count...
  2. Dagfish

    Leading zeroes in times (Excel/csv)

    I am about to receive hundreds of Excel spreadsheets, of which one of the five columns is a time in the format hh:mm The format of this source file is fixed and can not be changed. I need to open each of the spreadsheets and save as a csv file. If I do this manually, I experience no problems at...

Part and Inventory Search

Back
Top