•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Change the number format correctly
Our take
If you've accidentally entered time data in Excel using the "Number" format instead of the correct time format, you're not alone. Changing the format to "[h]:mm:ss" can trigger unwanted recalculations, complicating your dataset. Given that you've already entered 830 rows, retyping everything manually is impractical. Fortunately, there are efficient solutions available. By utilizing a macro or specific formula, you can transform your entries into the correct format swiftly and accurately, saving you hours of work while maintaining data integrity.
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]
Read on the original site
Open the publisher's page for the full experience
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