function works on some sheets but not others

  • Thread starter Thread starter danafeldman
  • Start date Start date
D

danafeldman

I'm trying to combine a number and word using the &. The formula bar says
=2007&"utah", and it's giving me a #value error. When I copy the cell and
paste it in the next tab, I get the result 2007utah, which is what I wanted.
I can't do anything to get it to work in the first tab though. Are there
some reasons it might work in one tab but not another?
 
maybe by putting 2007 in quotes & defining it as text, that would
work..........

="2007" & "utah"

both in quotes & not in quotes works for me.
hope that helps
susan
 
Thanks for the suggestion Susan. It does work in quotes, but I need it to
work as a value since the 2007 will actually be a variable. Plus, I don't
need to use quotes to make it work on the following tab, so not sure why it
would be different on the 2 tabs.
 
You have transition turned on in the sheet that returns the error


Tools>options>transition and clear the "transition formula evaluation" check
mark

Your spreadsheet might originally have been created in Lotus 123?

Every time one gets a strange value error check there first

It happens with a lot of date formulas for instance

--


Regards,


Peo Sjoblom
 
That was it - thank you!
--
danafeldman


Peo Sjoblom said:
You have transition turned on in the sheet that returns the error


Tools>options>transition and clear the "transition formula evaluation" check
mark

Your spreadsheet might originally have been created in Lotus 123?

Every time one gets a strange value error check there first

It happens with a lot of date formulas for instance

--


Regards,


Peo Sjoblom
Click to expand...
 
Back
Top