Forum Discussion
A challenge Excel 2019 changes formatting of @ text field when entering 1- changes format to General
I have seen some funning things in my time but I cannot seem to get around this (Excel 2019 local app) A table with heading all formatted using @ so should be all text but if I enter 1- and then ...
Wyn Hopkins thanks makes sense but sadly cannot turn off
You could change the Table back to a range but then you would lose the benefits of Table functionality