•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Change the number format correctly
I accidentally entered the time as "3:04" using the "Number" format, with minutes first, followed by a period, and then seconds. If I change the number format now to "[h]:mm:ss", the numbers change because Excel recalculates the date. I’ve already entered 830 rows, and it would take hours to retype everything manually. Is there a macro or some kind of formula or rule I can use to change everything to the correct format at once?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com