remove '0 in front of number

W

willemeulen

I have a whole bunch of number in columns written as follows

'08344555
'09783593

etc

How can I edit the cells in one go instead of removing all by hand

Thanks,

W
 
F

Fred Smith

It would help if you told us what you want to achieve by the "edit". Turn
them from text into numbers? Just remove the zero from the text? Something
else?

Here are some things you can try:
1. Use Text to Columns.
2. Put zero in an empty cell. Copy it. Highlight your column, right-click,
choose Paste Special...>Add.
3. In a helper column, use the formula =--right(a1,7) and copy down [adjust
the range to suit].

Regards,
Fred.
 
P

Per Jessen

Hi

In an unused cell enter 1, then copy this cell. Select cells to convert >
Paste Special > Multiply > OK

Regards,
Per
 
P

Pecoflyer

WHY NOT ADD A WORKBOOK?
Providing a workbook will not only get you your answer quicker but will
better illustrate your problem, usually when we can see your data (-it
can be dummy data but must be of the same type-) and your structure it
is far easier for us to give you a tailored, workable answer to your
query :)
 
Top