ExcelBanter - auto correct option

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

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - auto correct option (https://www.excelbanter.com/setting-up-configuration-excel/162629-auto-correct-option.html)

aavasilenko

auto correct option

Hello there.

Please say if you know how to switch-off auto correct options from 01/01 -
9-12 to 1st January and 9 December respectively,

Thanks a lot

Dave Peterson

auto correct option

You can preformat the cell as text and then do your data entry.

You can prefix your entry with an apostrophe: '01/01

aavasilenko wrote:

Hello there.

Please say if you know how to switch-off auto correct options from 01/01 -
9-12 to 1st January and 9 December respectively,

Thanks a lot

--

Dave Peterson

All times are GMT +1. The time now is 09:08 AM.