Date time format numbers ipad

albuquerque_ed wrote:

My spreadsheet is just too big to delete and reenter all the dates. It is simply a cosmetic issue that I will just have to live with.

I'm curious why you've come to that conclusion, especially in the face of clear evidence to the contrary (see my screenshots above).😀

No one has suggested deleting and reentering all dates. if you're having trouble getting the formats in existing cells to adjust (even after selecting 24-Hour Time and other settings in my screenshots above), then on the Mac insert a new blank column, make sure all formats are cleared out of it by selecting the cells in the new column and hitting <delete>, then format those new cells with Date & Time with the leading zeros as I've shown above. Then you can select your existing dates, command-c to copy, and in the new column Edit > Paste and Match Style. Then, with cells still selected, make sure Date & Time is still applied in the dropdown in the panel on the right.

On the iPad, if you're entering dates de novo you need to make sure 24-Hour Time is turned on at Settings > General > 24-Hour Time (both on the Mac and iOS you HAVE done that as shown above, right?), and then you go through essentially the same process as described in a prior post to make sure new date-time strings are displayed with your desired format. Sometimes when you've changed settings the cells flip back to 'Automatic' so you need to go back in change back to 'Date & Time'.

I assure you that my times in Numbers for iOS do display with a leading zero. So they can for you too!

I'm a little shocked that someone who can navigate Brand-X and Linux would be stymied by simple settings like this!😀 And that someone who started with an Apple II and a Tandy TRS-80 (and maybe even before that had a Digi-Comp as a kid) would suggest this can't be done.😀

SG