| 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 |
| 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 | |||
Threaded Mode
