text and number

I

Ian Elliott

Thanks for any help.
I am trying to get a cell with a formula and text.
Something like for A1
=B1*C1&"% - "&D1*E1
But I get a #VALUE! error for this. However, when I opened another new
workbook, I could do it without error. I tried changing the cell format to
general, but to no avail. Any ideas?
Thanks.
 
B

Bob Phillips

=B1*C1&"% - "&D1*E1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
G

Gord Dibben

Perhaps one or more of the values in B1:E1 are text and not real numbers?


Gord Dibben MS Excel MVP
 
D

Dave Peterson

And you're positive that all your values are numbers--none of that HTML
non-breaking spaces in any of those cells, right?

If you're positive, then try toggling this setting:
(in xl2003 menus)

Tools|Options|Transition tab|Uncheck Transition Formula Evaluation

In fact, I'd recommend that you turn off all those Lotus 123 settings. They're
more irritating than useful (to me, at least).
 
Top