Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag for United States of America

asked on

Excel Formulas Don't work

I have an excel spreadsheet. I want to add a formula to a cell like =A3&".jpg".

It doesn't work. Nor does just plain =A3.

Excel 2010. What do I have to do to make it allow this?

Thanks
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

If worksheet cells do not seem to be calculating when changing worksheet cell values or copying cells containing formulas then workbook or worksheet calculation is turned off. To turn on automatic calculation choose the menu command Tools->Options, navigate to the Calculation tab, select Automatic, and click OK. In Excel 2010 click on File, select Options, select Formulas, and make sure calculation mode is set to Automatic.

Note that in some cases manual calculation may make more sense such as when there are many calculations, complex calculations, or many UDF references which cause every calculation to take more than a second or two.

Note that a workbook can be manually calculated at any time by pressing F9.

Kevin
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What do you mean when you say "it doesn't work"? with "test" in A3 and =A3&".jpg" as the formula in B3, B3 will be "test.jpg".
Avatar of Richard Korts

ASKER

To all,

Automatic is turned on in Formula Calculation options.

In my many years of working with Excel, if you type "=A3" into any other cell, it puts the contents of A3 into that cell. In this one, it says =A3. Not what I want.

Something is screwy.

Note I was emailed this spreadsheet, but it is an xlsx (as opposed to xls).
Is the cell formatted as Text?

Kevin
To Kevin,

The cells are formatted as text. That's what they should be. they are NOT numbers. How should they be formatted?
You're actually typing =A3 and not "=A3" right?
Also, be aware that Excel has a rather dastardly feature that if A3 is formatted as Text and you enter a formula referencing A3 in another cell, that cell will be automatically be formatted as Text. Microsoft has been notified of this behavior and hopefully will address it in a future version.

Kevin
To all.

I formatted them as "General". It now works.
>The cells are formatted as text. That's what they should be. they are NOT numbers. How should they be formatted?

Anything BUT Text. Anything entered into a cell formatted as Text will NOT be calculated and will be displayed as-is.

Kevin