Hi,
I am so grateful that you and others are so willing to teach me stuff in details.
Yes, I know the "ADD" method. But, I learn the "MULTIPLY" method first and then Excel Help highlights that method, therefore ......
Now that you have spelled out the advantages of using "ADD," I'll convert from now on.
I don't like the Text to Column method which I find confusing. After the conversion, the numbers are still left-aligned. Also, when I do format>cells>number to check, it still shows "Text" and not "General." I wonder why it has not been changed. I have to use ISNUMBER ( ) to check.
I think MS should make some changes including Help.
Epinn
Epinn - FWIW,
It might be considered as a better approach to use an *empty* "General"
formatted cell for this procedure, and then in "Paste Special", use ADD.
The advantage of using this technique is that empty, blank cells will *not*
then display 0's.
This allows a more general and quicker selection to be made, where the
selection can include an all encompassing block of cells, both empty *and*
containing the data to be converted, instead of making it necessary to
select the data cells individually, in order to avoid the insertion of 0's.
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
Please have a backup copy before you convert.
If you wait, someone may provide you with a macro???
Epinn
I don't blame you ......
Following from Excel Help:-
1.. Select a blank cell that you know has the General number format.
2.. In the cell, type 1, and then press ENTER.
3.. Select the cell, and then click Copy on the Edit menu.
4.. Select the nonadjacent cells or ranges of cells that contain the
numbers stored as text that you want to convert.
5.. On the Edit menu, click Paste Special.
6.. Under Operation, click Multiply.
7.. Click OK.
Tip If all the numbers are converted successfully, you can delete the
content of the cell that you typed in Step 2.
Hope this helps.
Epinn
Hi all,
Need some help.
One of my main data for my job, is in Excel format. The problem lies with
the cell format. All number being stored as text. I need to do error
checking
and then keep pressing C on the keyboard ( for converting to number ) . It
took between 30 to 45 minutes pressing time before it finally completed.
Is there any way to remove this "Pressing Job" as it really irritates me.
