Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted character | Excel Worksheet Functions | |||
install Office Assistant character file? | Excel Discussion (Misc queries) | |||
Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
Removing ' character from cells | Excel Discussion (Misc queries) |