You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

I have 2 columns in number that need to be military time format. When 09:00 is entered it changes to 9:00

I have 2 columns in number that need to be military time format. When 09:00 is entered it changes to 9:00

iPad Pro 10.5-inch, Wi-Fi

Posted on Aug 28, 2019 2:45 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 28, 2019 3:47 PM

Hi MT,


Enter the times as text. You can either format the columns as text, or type an apostrophe to "force" text format. For example, type '09:00


Numbers will recognise the text as valid times.


Regards,

Ian.

3 replies

I have 2 columns in number that need to be military time format. When 09:00 is entered it changes to 9:00

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.