Can’t change format of a cell in Numbers on iPhone nor iPad

I’ve got a duration value in a Numbers sheet with an existing Automatic format. In this case, the value is the duration “23:57”. I want this to be reformatted as “23m 57s”.


Here’s my process that is NOT working:


Click the cell to be reformatted.

Click the Paintbrush icon.

Click Format.

Click Duration.

Uncheck Automatic Units.

Select Min Sec as the units.

Click Short as the format.

Click the Paintbrush icon.


The format does NOT change and it still shows “23:57” as the Automatic format.


This same behavior also happens when attempting to change the format of a whole column.


What am I missing? How do I change the Automatic format to a Duration format?


Thanks in advance,


Blaine

iPhone 14 Pro, iOS 18

Posted on Jun 21, 2025 11:37 AM

Reply

Similar questions

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Can’t change format of a cell in Numbers on iPhone nor iPad

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