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
|