I am new to Numbers- how do I stop auto formatting of text? Every time I type '2hrs' (as in 2 hours) it changes to '2h'. Also, when I type the date as '28-Jan' it changes to 28/1/15. I have already tried unchecking text replacement under substitutions, as well as unchecking correct spelling automatically under spelling and grammar. Thank you!
MacBook Air, OS X Yosemite (10.10.1)
Hi Katelyn,
You can format your cells as text and Numbers will not change things but I do not think that is what you want. I thnk you want a date to remain a date and a duration to remain a duration but with the formatting you want. You can do some of this. You want to create a custom format. You will find it in the data format menu.
For durations you are not so lucky here are your options:
If you are not doing any calculations on these numbers you can convert them to text format. They will show the way you enter them and you may be able to add them sometimes. If you do add them they will show as the single "h".
I hope this helps,
quinn
Quinn you are the best, that has solved it!! I created a custom format for the date, and formatted the duration ones as text.
Thank you so much!!!
Hi Katelyn,
Glad that worked for you. I feel badly I didn't try harder to convince you to let the durations be. It could come back to trouble you.
quinn
Don't worry at all, I am only using the spreadsheet to fill in my timesheet for work which I then add hours together manually anyway so it won't be an issue!
Thanks again for your help!!
How to stop auto formatting of text
