#VALUE! error - Occurs when the wrong type of argument or operand

  • Thread starter Thread starter Allan
  • Start date Start date
A

Allan

Regarding Excel 2003 - I copied a range of (what I thought were) numbers from
a webpage into a sheet. When I then tried to work with these numbers I got
the above error message. In tracing the formula problem, there appeared in
the trace box a double quote (") ahead of the number indicating that it's
really text. I tried to use the =value( ) function to convert the text to
numbers but this returned the same error. The double quote (") does not
appear in the cell editing box and no amount of fomatting seems to work. Any
suggestions?
 

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

Access My Expression Contains Wrong number of arguments 0
Error: Compile Error,ByRef argument type mismatch 0
sustain numbers with double quotes 7
Access Switchboard error message 1
Auto rounding of large numbers 2
text to numbers 1
Convert Grams to Pounds 3
Compile Error: Wrong arguments or Invalid property 3

Back
Top