#VALUE! - Numbers Formatted as text

Adam · Oct 31, 2004

Hi All,

I have created a monster spreadsheet that pulls in data from other
spreadsheets (12 in all).

Now I have it pull the information from each spreadsheet into its own rows.

I then have a total so (=a1+a2+a3+a4 etc) but it is returning the error
#VALUE!

Now I believe this is because the data I'm adding is formatted as text even
though its a number. How can I format this back to be truly a number?

--
Thanks

Adam

====================
Windows XP Pro + Office 2003 Pro

Dave Peterson · Oct 31, 2004

Try copying an empty cell and then select your range and
Edit|paste special|check Add under Operation.

Did you get the data from a web page?

If yes, maybe you've got those pesky HTML non-breaking spaces in the cells.

See David McRitchie's site to clean them up:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

And if you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

#VALUE! - Numbers Formatted as text

Adam

Dave Peterson