Removing zeros from data list

[mokihi]

I have a giant list in one column full of data that is prefixed by zeros.

eg. 271 is represented as 00271, 274 as 00274

I am trying to remove these zeros so as to be able to merge and sort this
data with another set.

Can anyone tell me how to remove these zeros from the data without manually
typing them in?

 

[Roger Govier]

Hi

How is the column currently formatted?
Is it Custom>00000?
If so, change the format to Custom>000
If it is Text, then copy a blank cell>mark the range of your data>Paste
Special>Add.
This should change you values from Text to Numeric.

 

[Glenn]

I have a giant list in one column full of data that is prefixed by zeros.

eg. 271 is represented as 00271, 274 as 00274

I am trying to remove these zeros so as to be able to merge and sort this
data with another set.

Can anyone tell me how to remove these zeros from the data without manually
typing them in?

It looks like the cells contain text. Put a zero in an empty cell somewhere and
then copy it. Select your column and Edit / Paste Special / Values / Add.

 

[muddan madhu]

enter the number 1 in any empty cell and copy that cell,
now select cells which has prefixed with zero's | go to edit |
pastespecial | click multiply | ok

 

[T. Valko]

Sometimes this will remove leading zeros from TEXT numbers and convert them
to numeric numbers.

Select the range in question
Goto the menu Data>Text to Columns
Click Next twice
In step 3 make sure Column data format is set to GENERAL
Click Finish