ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   autocorrect question (https://www.excelbanter.com/excel-programming/375516-autocorrect-question.html)

j.amanda.j

autocorrect question
 
I'm using office xp and have turned off every tab in every application
I can find, but when I type "march-04" into excel it automatically
changes it to "4-march." Please help!
thanks,
amanda


AndrewArmstrong

autocorrect question
 
Amanda,
Select the range in question, and right click, then choose Format
Cells. Click on the Number Tab, then choose Date on the category on the
right, and select the desired format.
Hope this helps!
Andrew Armstrong



All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com