View Single Post
  #2   Report Post  
Alok
 
Posts: n/a
Default

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