leadin zeros

S

SVRHC

Imported a download file. 1 of the fields is zero filled, right justified. How do I hide all the leading zeros?
 
F

Frank Kabel

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?
 
Top