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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have several columns of cells in the Duration format. If I make a mistake entering the Duration, the cell format changes to Automatic (which does not include Duration) or Text, or Number, etc.)
MacBook Air, macOS 14.3
You cannot lock a cell's format.
But are you entering Duration? If you use the input shorthand it's harder to get wrong.
For example instead of 11:30 enter 11h30m.
In English you have w, d, h, m, s, and ms to work with. In other languages use similar shorthand.
When you enter Duration using shorthand you can still display it as, say, 11:30 if you want, by picking that style in the dropdown.
SG
Can you lock just the cell FORMAT, not the cell?
