As Arvi says, your example isn't a number. It's text which happens to include numerals, eg 123 Main St #7. So format those as text.

I find Excel is pretty good at keeping numbers as numbers. Special kinds of numbers, like currency, percents & dates, will usually require an extra formatting step to select how you want them displayed—eg July 27 or 2019-07-27 or…