Auto Correct - Just one spreadsheet

[John_McClane]

Hi,

I have a spreadsheet that has to have numbers inputted as text. So I have added to auto-correct as i type all the numbers to text, i.e "3" to "Three" which worked great....

Then I opened another spreadsheet that I needed numbers in. Of course it changed all the of them to text.

Is it possible to apply an auto-correct as you type to only 1 spreadsheet and not across excel as a whole?

Thanks

 

[John_McClane]

Quick Update:

Have found a way around it, sort of. Have recorded a macro to add/remove the auto correct settings and then set them to run on workbook open/close. It does mean however that it will apply to other workbooks if you have them open at the same time, so if anyone knows if it's possible to do it another way, help would be greatly appreciated.

John