Excel Tips: Name versus Amount

To input data beginning with zero (for a Suite number, for example), first input an apostrophe like so: ‘00724.  Otherwise, Excel will automatically delete the zero prior to the other numbers.

Comments are closed.