remove zero

  • Thread starter Thread starter capreecorn
  • Start date Start date
C

capreecorn

How can i delete zero in start of value by using formula i.e (0000010 in to 10)
 
Hi,

The answer depends on how the ones are put there. If it is a text string
then put a 1 in a cell (any cell) and copy the 1. select this number or range
of numbers and then

Edit|Paste special - select multiply and click OK

If the zeros are the result of a format then simply re-format as a number.

Mike
 
I supposed that 0000010 is a text string. If you want to convert it to a
number (10) then
=VALUE(A1)
If you want to convert it to a text ("10") then
=TEXT(VALUE(A1),"@")

Regards,
Stefi

„capreecorn†ezt írta:
 
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

delete a prefix 3
Skip the Zeros in a chart 4
Delete Rows with Conditions 1
Macro required 4
Combining Text based on Values 8
removal of first digit on left in cell 5
Print variable number of rows of spreadsheet 1
Count every group of numbers whose sum is zero & put number next toeach number 6

Back
Top