Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m Frustrated this is not in book

How do you create custom date formats?

Your book has what the standard data formats are, but there is NOTHING as far as I can tell about creating custom data formats and creating rules to go with the custom formats. One of the most basic custom formats that I use is where the cell automatically customizes a series of numbers into a phone number format. I am now trying to create on that will format a group of numbers into swim times. I want the ##:##.## when the time is over a minute, but I want it to show as ##.## only when the time is under a minute. There is no guidance in your book on this very important functionality available in Numbers. I can't believe you left it out.
1 person has
this question