Disable Auto-Formatting for a Cell or Range Formatting a cell or range as text is one of the easiest ways to prevent Excel from automatically altering your data. This ensures that the data stays ...

Excel saves the data as text, meaning it might not work for mathematical calculations. Also, there's a known issue that doesn't support the disabling of auto-conversions when running macros.