Where did you get the numbers from, web page or import?

Try this, assuming the values are in A1:A20,
select A1:A20, do editreplace, click in the find what box and hold down alt
while typing
0160, release the alt key

now sum them


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)



"EricB" wrote in message
...
Hi Gord Dibben

Still no luck. Any other advice?

Regards

Eric

"Gord Dibben" wrote:

Eric

Format all to General or Number then copy an empty cell.

Select your data range and Paste Special(in place)AddOKEsc.

Or run the range through the DataText to Columns Wizard making sure at
third
step the Column Data Format is set to General(default).


Gord Dibben MS Excel MVP


On Fri, 5 Jan 2007 00:39:00 -0800, EricB

wrote:

Hi Corey
The range of values 'seem' to be in the wrong format and this is
probably
where the problem is, but trying to convert the non standard number to a
valid number is the challenge

"Corey" wrote:

did you check the range it is adding?
"EricB" wrote in message
...
Autosum retorn a '0' Value on a Data Sheet. I have formatted the
cells to
numbers and various other which has no impact. Copy & Special Paste
did
not
have any effect. Please assist.