21st January 2006, 10:19 AM
|
|
Banned
|
|
Join Date: Mar 2005
Posts: 1
|
|
Quote:
|
Originally Posted by La Mer
I'm sure that this question has been asked before on this forum, but I want to convert text into numbers, e.g. I have SP data that is stored as text such as 100/1, 20/1 etc which I wish to convert to a numeric format.
Can anyone help please.
|
In Excel you can do a find and replace. Find "/1" and replace it with nothing.
Then run another column with a formula (format cell to currency) that adds one to the number on left.
Therefore 100/1 has become 100 then in next column $101.00
For prices such as 5/2, 7/4 etc, you figure these manually, do a sort and do a copy and a mass copy into those cells. |