I'm working in Numbers right now, and I need to write a date in this format "December 10, 2013" but when I write that, it changes to "Dec 10, 2013." How do I make the program not do that?!? It is really annoying. 😠
MacBook Air
Format the cell to display the date the way you want it to be displayed. That style is one of the choices, at least in the US English localization. Pre-format all the cells you plan on putting these dates into and it will be "correct" from then on for those cells.
Format the cell to display the date the way you want it to be displayed. That style is one of the choices, at least in the US English localization. Pre-format all the cells you plan on putting these dates into and it will be "correct" from then on for those cells.
Is there a way that I don't have to change the format in the settings every time I want a different format? Is there a way that I can type in a date and not have the format change? Or do I really have to change the format in settings everytime I need a different format?
Penopoly wrote:
Is there a way that I don't have to change the format in the settings every time I want a different format? Is there a way that I can type in a date and not have the format change? Or do I really have to change the format in settings everytime I need a different format?
The Automatic Format should allow that.
Jerry
In Numbers 3.0, if I type in December 10, 2013 it stays formatted that way. And that is true for any other way I type in a date (as long as it is an acceptable format); they stay just as I typed them.
In Numbers 2.3 (Numbers '09), though, the default format is Dec 10, 2013 no matter how I enter the date. The only way to get around it is to pre-format the cell(s). If you are often changing formats as you enter dates and you want them to display as typed, you will often be going to the cell tab of the inspector and changing the format. But this is not typical. Typically you want all the dates formatted the same way so pre-formatting the cells is a one-time action.
Okay so basically there's no way to keep the dates in the format I write them, so everytime I want a different format of a date I have to go in and manually change it in the settings. Am I understanding correctly?
Penelopy,
type the date in numbers, then format the cell using the cell formatter:
Select the date format you want from the date format menu:
And now the date will "look" the way you want even though you typed in the date in a different way. So long as you type a valid date Numbers will display it in the selected format as selected by you or the default:
I'll wait for Jerry to verify what I've said. I think he may have given an answer for Numbers 3.0. You never said which version you are using. I'm assuming Numbers '09. And in that case, yes, you will need to change it in the cell inspector.
Penopoly wrote:
Okay so basically there's no way to keep the dates in the format I write them, so everytime I want a different format of a date I have to go in and manually change it in the settings. Am I understanding correctly?
No, read my post above. Use Automatic.
Jerry
I want to write a date in a certain format, but it keeps changing it to a different format.
