Unwanted character

M

martina.mangan

Hi Group,

How can I use excel to convert '041255354412 into 041255354412

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

kind regards

Martina
 
A

Alok

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
 
R

Ron Coderre

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
 
Top