Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function works on some sheets but not others
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? -- danafeldman |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function works on some sheets but not others
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 On Oct 13, 1:36*pm, danafeldman wrote: 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? -- danafeldman |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function works on some sheets but not others
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. -- danafeldman "Susan" wrote: 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 On Oct 13, 1:36 pm, danafeldman wrote: 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? -- danafeldman |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function works on some sheets but not others
You have transition turned on in the sheet that returns the error
Toolsoptionstransition 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 "danafeldman" wrote in message ... 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. -- danafeldman "Susan" wrote: 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 On Oct 13, 1:36 pm, danafeldman wrote: 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? -- danafeldman |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function works on some sheets but not others
That was it - thank you!
-- danafeldman "Peo Sjoblom" wrote: You have transition turned on in the sheet that returns the error Toolsoptionstransition 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 "danafeldman" wrote in message ... 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. -- danafeldman "Susan" wrote: 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 On Oct 13, 1:36 pm, danafeldman wrote: 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? -- danafeldman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function works in one cell but not another | Excel Worksheet Functions | |||
Can someone test this IF function for me, I'm not sure that it works. | Excel Worksheet Functions | |||
SMALL FUNCTION - How it works | Excel Discussion (Misc queries) | |||
how pmt function works, what is its background / machanizm? | Excel Worksheet Functions | |||
Worksheet function in excel only works once | Excel Worksheet Functions |