I have columns of "data" pasted from elsewhere which should be numbers but appear as text. Each number has a space before it, and when I remove this it makes it back into a recognised number.
2007-03-07 00:02:59 · 4 answers · asked by VBproblem 1 in Computers & Internet ➔ Programming & Design
In broad terms I would refer you to mrexcel.com
The macro that you want is there in the archives.
Just got to the message board and search using your question
Also, this might help: http://www.mvps.org/dmcritchie/excel/join.htm
And there are many variants if you search using your question, again
2007-03-07 00:06:26 · answer #1 · answered by Mictlan_KISS 6 · 0⤊ 0⤋
=trim(CELL ID)
Of course you can fill this formula to the whole column and it should work fine.
Then you can select the whole column, right click and go to format cells - then under "number" you can select whatever format you want, number, text whatever.
2007-03-07 08:08:52 · answer #2 · answered by Hamza 2 · 0⤊ 0⤋
Let me show you another.
Type 1 in any empty cell. Copy it.
Select whole range you want to convert as numbers.
Go to edit/pastespecial/paste as value|operations as multiply
2007-03-07 10:37:06 · answer #3 · answered by unnga 6 · 0⤊ 0⤋
Download and install this http://www.asap-utilities.com/ I promise you will thank me for this and best of all it's FREE
2007-03-09 08:40:06 · answer #4 · answered by orchie1 2 · 0⤊ 0⤋