How to add 0's in time cel

  • Thread starter Thread starter Kash
  • Start date Start date
K

Kash

Hi,

I import a text file in Excel & the data has no
regularity. Most of the cells in that text file are
calculated time fields (HHHH:MM:SS) and they show up like
this:

2323:52:15
:05:35
:05

I was wondering if there is any way in Excel that you can
either add zeros before the minutes or seconds to get
regularity because I have to export that data into Access
Database & if there is no regularity then I cant calculate
time or run reports in Access. I even tried to have input
mask on all the table field in Access but it doesnt work.
I would appreciate any assistance.

Thanks,

~Kash
 
Back
Top