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.

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 ...