delete leading 0
They've apparently been imported as text strings rather than numbers. To
convert, type a 0 in some empty cell and copy it (ctrl+C). Then select your
imported data and, from the menu bar, Edit Paste Special, select Values and
Add, then click OK.
"Hal B" wrote:
I have a download in Excel, but the numbers have leading zeros (e.g. 00796,
01234). How do I delete these?
|