How do I fix the format of the time on data if the format is (A ":16" ) and the format should be (B "00:00:16") unfortunately when i extract the data it is given in this format.
Is there a way i can change A to B?
Thank you for your help Zain.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Time Formats
0
Answers
0
Used find and replace...in FIND put A; then in REPLACE WITH put B.
Discussion
Hi Thanks for this, B varies sometimes its a different value, the above is an example of on of many.
Zain Jul 15, '17 at 12:26 am