ExcelBanter - autoformatting issues in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - autoformatting issues in excel (https://www.excelbanter.com/excel-discussion-misc-queries/10792-autoformatting-issues-excel.html)

student

autoformatting issues in excel

How do I input '12-1' in excel without it autoformatting my input to '1-Dec'?

Peo Sjoblom

Precede entry with apostrophe '

Regards,

Peo Sjoblom

"student" wrote:

How do I input '12-1' in excel without it autoformatting my input to '1-Dec'?

All times are GMT +1. The time now is 12:22 AM.