Unwanted character
 

Hi Group,

How can I use excel to convert '041255354412 into 041255354412

That is omit the "'" from the string of numbers.

kind regards

Martina

Hi
If you just want to convert what is text right now to a number then type a 1
in any unused cell. Copy the cell. Then highlight the text string or a whole
range of strings and select menu option Edit/Paste Special/Multiply
Alok


" wrote:

Hi Group,

How can I use excel to convert '041255354412 into 041255354412

That is omit the "'" from the string of numbers.

kind regards

Martina

Depending on your needs, here are some options:

If '041255354412 is in A1 then these work:

Method 1:
B1: =VALUE(A1)

Method 2:
=A1*1

Method 3:
Put a 1 in any cell and Press [Enter]
Select that cell
EditCopy
Select Cell A1
EditPasteSpecial
Check Multiply and Values
Click OK

Note: In all of those methods, you'll lose the leading zero. You can
re-display it using a custom number format.

I'm sure there are other ways I haven't mentioned.

Does that help?

Ron

--
Regards,
Ron


" wrote:

Hi Group,

How can I use excel to convert '041255354412 into 041255354412

That is omit the "'" from the string of numbers.

kind regards

Martina