💻 Software
How do I force a user to use a specific format when entering time data?
Fresh5 days ago
Mar 15, 202625540 viewsConfidence Score0%
0%
Problem
I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force a specific formatting for a range of cells?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I force a user to use a specific format when entering time data?
Low Risk
I'm using Excel 2010 so I'm not sure where the equivilent option is in Excel 2003. Select the cells you want to restrict. Format the cells with the appropriate number format "hh:mm". In the "Data" ribbon (menu, maybe?), select "Data Validation". Und…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix