•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
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#AI formula generation techniques
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#formula generator
#Excel
#number format
#time
#[h]:mm:ss
#macro
#formula
#recalculate
#data entry
#rows
#manual entry
#correct format