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


"[email protected]" 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
Edit>Copy
Select Cell A1
Edit>PasteSpecial>
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


"[email protected]" 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
>