leadin zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Imported a download file. 1 of the fields is zero filled, right justified. How do I hide all the leading zeros?
 
Hi
try the following:
- select the data and apply the 'General' format for these cells
- select an empty cell and copy it
- select your data range
- goto 'Edit - Paste Special' and choose 'Add'

--
Regards
Frank Kabel
Frankfurt, Germany

SVRHC said:
Imported a download file. 1 of the fields is zero filled, right
Click to expand...
justified. How do I hide all the leading zeros?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Leading Zero Question 7
Need 7 digit number with differnt number of leading zeros 10
Leading Zero 11
leading zero & .csv files 4
Replacing cell numbers but leaving leading zero 1
Download/Import from Tab Delimited - Formatting of Data 5
How to stop Excel from automatically truncating leading zeros 2
Lead Zeros in Text 6

Back
Top