Concatenate function WON'T concatenate!! Why?

mobius · Mar 4th, 2002, 12:18 PM

Hi, Folks! Hope someone can help me!

Am trying to use concatenate function to two cells - the results in the function dialog box are correct as I select cells to apply the fucntion to - BUT when I click OK, the results cell contains the formula and NOT the result. I'm seeing the same thing attempting other text functions, as well!

Can anyone give me an idea of why this behavior is happening? Anyone else experienced such a thing?

Thanks for your assistance!!

CR

Ian Mac · Mar 4th, 2002, 01:11 PM

Quote:

On 2002-03-04 11:18, mobius wrote:
Hi, Folks! Hope someone can help me!

Am trying to use concatenate function to two cells - the results in the function dialog box are correct as I select cells to apply the fucntion to - BUT when I click OK, the results cell contains the formula and NOT the result. I'm seeing the same thing attempting other text functions, as well!

Can anyone give me an idea of why this behavior is happening? Anyone else experienced such a thing?

Thanks for your assistance!!

CR

Try:

Tools/Options/View then check to see if the Formulas box is checked, it shouldn't be.

Any help

mobius · Mar 4th, 2002, 02:07 PM

Ian: Thanks, but no good so far - my box is unchecked

... the problem seems to be with macros embedded in the spreadsheet. I notice that any .xls's with macros exhibit the inability to run functions!

I'm trying to see if anyone else is seeing the same nonsense.

Ian Mac · Mar 4th, 2002, 02:12 PM

Quote:

On 2002-03-04 13:07, mobius wrote:
Ian: Thanks, but no good so far - my box is unchecked

... the problem seems to be with macros embedded in the spreadsheet. I notice that any .xls's with macros exhibit the inability to run functions!

I'm trying to see if anyone else is seeing the same nonsense.

Send me your book if you want

mobius · Mar 5th, 2002, 06:17 AM

Ian:
Thanks for the offer, but I think I've got it figured out - Excel doesn't like to concatenate numbers which have been formatted as text (i.e. zipcode data) - by using 'general' format I've fixed most problems.

Thanx again!

CR

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 12:18 PM	#1
mobius New Member Join Date: Mar 2002 Posts: 5	Hi, Folks! Hope someone can help me! Am trying to use concatenate function to two cells - the results in the function dialog box are correct as I select cells to apply the fucntion to - BUT when I click OK, the results cell contains the formula and NOT the result. I'm seeing the same thing attempting other text functions, as well! Can anyone give me an idea of why this behavior is happening? Anyone else experienced such a thing? Thanks for your assistance!! CR

Mar 4th, 2002, 02:07 PM	#3
mobius New Member Join Date: Mar 2002 Posts: 5	Ian: Thanks, but no good so far - my box is unchecked ... the problem seems to be with macros embedded in the spreadsheet. I notice that any .xls's with macros exhibit the inability to run functions! I'm trying to see if anyone else is seeing the same nonsense.

Mar 5th, 2002, 06:17 AM	#5
mobius New Member Join Date: Mar 2002 Posts: 5	Ian: Thanks for the offer, but I think I've got it figured out - Excel doesn't like to concatenate numbers which have been formatted as text (i.e. zipcode data) - by using 'general' format I've fixed most problems. Thanx again! CR