Forum Discussion
User537843
Sep 26, 2023Copper Contributor
Time To Change
When I type " 7 AM ", it converts it into 7:00:00. How to disable that.
NikolinoDE
Oct 01, 2023Platinum Contributor
In Excel for Mac, the behavior you are encountering where it automatically converts "7 AM" into "7:00:00" is due to Excel recognizing your input as a time format. If you want to prevent Excel from automatically formatting your input as a time, you can follow these steps:
- Open Excel on your Mac.
- Click on "Excel" in the top menu bar (next to the Apple logo).
- Select "Preferences."
- In the Preferences window, select "Edit."
- Under the "Editing options" section, uncheck the option that says "Automatically insert a decimal point."
- Click the "OK" button to save your changes.
Now, when you type "7 AM" or similar text, Excel should no longer automatically convert it into a time format. This change should prevent Excel from interpreting your input as a time and displaying it as "7:00:00". The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.