| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#VALUE! when adding numbers
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#VALUE! when adding numbers
You have one response to your other post in .misc
Adam wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding top 10 numbers from 100 | Excel Discussion (Misc queries) | |||
| Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
| adding + and - numbers | Excel Worksheet Functions | |||
| Adding numbers to current numbers | Excel Worksheet Functions | |||
| Adding Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
