#VALUE! when adding numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?

Many Thanks for your assistance.
--
Thanks

Adam

====================
Windows XP Pro + Office 2003 Pro
 
You have one response to your other post in .misc
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?

Many Thanks for your assistance.
--
Thanks

Adam

====================
Windows XP Pro + Office 2003 Pro
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#VALUE! - Numbers Formatted as text 1
How to delete ALL cells containing the same data 1
Remove specific cells in a column. 2
Removing Sequential Numbers 4
userform exception error 4 textboxes 7
Sum number range ignoring numbers formatted as text 0
Copy value 8
Variable SUM range 16

Back
Top