I copied and pasted from the screen the attached file. The score column showed up as text. I have used every trick I know to convert it to numbers without success. Any help would be appreciated.
I copied and pasted from the screen the attached file. The score column showed up as text. I have used every trick I know to convert it to numbers without success. Any help would be appreciated.
Do you wish to remove the % sign and just see 82.55, 92.92 etc...?
In G3 put this formula and pull it down.
=VALUE(LEFT(F3,LEN(F3)-1))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Maybe something as simple as this:
- Select column F
- Click Data in menu bar select Text to Columns
- Then select Delimited click next uncheck all the check boxes
- Click Others enter % in the box
- Select the none in Text Qualifer click next change the Destination to the Desired
- Click Finish
Hope this helps!
ILI
THANK YOU it worked. Perfect.
Hi,
Be careful what you think is working. If your text says 85.55% and you use the Text To Column feature in the steps above you will get
85.55 which isn't .8555
By throwing away the percent sign, your values are 100 times bigger than they really are.
That may not hurt your problem but still 85.55 <> .8555.
If this is solved. You might want to close the thread. Cheers!!!
Good luck
You are right Marvin. Thanks for pointing that out. I should have mentioned that. Sorry about it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks