I pulled these numbers (copy / paste) from a website and I am just trying to do some basic math? Averages and Deltas. It's like it doesn't recognize them as numbers? Sorry I know this is probaly real basic stuff.
I pulled these numbers (copy / paste) from a website and I am just trying to do some basic math? Averages and Deltas. It's like it doesn't recognize them as numbers? Sorry I know this is probaly real basic stuff.
Last edited by bythel2023; 04-08-2009 at 11:22 PM.
Funny stuff, that sheet of yours. Your numbers are indeed text, and apparently surrounded by hidden spaces. And not normal spaces, weird ones that Excel has difficulty spotting.
I had to highlight one of the cells, press F2 to enter the cell, the highlight one of the spaces IN the cell, then CTRL-C to copy it into memory.
Then I highlighted ALL your data and pressed CTRL-H to open the Search/Replace window.
I pasted the weird space into the FIND section, left the REPLACE line blank and clicked on REPLACE ALL. Done.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
hey! thanks alot for looking at that I really appreciate it. I followed your instructions and it replaced a bunch 12 or 1300 instances. did you fet the basic formulas that were in there to work? i can't seem to get them to add or average still?
Got it! Got it! Got it! back to your rockets! I saved it went through your process again and saved it again a voila!
thank you kind rocket scientist.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks