View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default 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?