Multiply two cells together

[jonathanschade]

I am new to tables. I am trying to eliminate "Spanner" from my daily work flow, and use tables. However I am not sure how to make this work with multiplication. I am using the formula "=(a2*c3)" and what I get in the cell is "####" (not what I want)
I assume that I am doing something wrong, but I don't know what. This equation works in Excel, why not in tables?
Thanks for the help
Jonathan

[ccowgill]

does a2 and c3 have numbers? if they are formated as text, that is the result you will get

[jonathanschade]

OK I am at a loss as to what I am doing. A2 and C3 have numbers in them, but I see no where to format them for numbers versus text.

[ccowgill]

what version of AutoCAD are you running?

[jonathanschade]

I am on 2006, but I was able to fix the problem. I was making it much harder than it should be, and I did have some text in the fields that I was trying to multiply. I got it fixed. Thanks for the help.