microsoft excel 2000 calculating problem

  • Thread starter Thread starter amitkabiraj
  • Start date Start date
A

amitkabiraj

hi,
i have faced the following problem

i entered 52.7 (A1)in a cell but it treated as character.
i set this as number after that i put formula "=A1*2" but showed
"#VALUE" in that cell .

how can i get rid of this problem?

bye
amit
 
If you are saying that you typed the text string "52.7 (A1)" into a cell,
then formatting it as a number won't turn it into a number, it will still be
text. If you want it as a number, you just need the 52.7
 
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

Greater Than Symbols and calculations 0
Excel Need Countifs Formula Help 0
Scrabble Value calculation for Welsh words 0
CSV->Excel Data Problem 1
Calculate next year in different cell 10
Excel does not calculate my formulas 13
Empty content after a calculation 4
Excel 2000 and date math 3

Back
Top