Left function

[dillonke]

Hi,
I'm moved from Excel 2000 to 2003 and now I find that the Left an
Right functions are not working correctly. They work OK if I type the
in one cell at a time but if I use copy/paste it just reproduces th
same result in every cell. This happens even if I use past
special/values as well!

Any ideas appreciate

 

[JulieD]

Hi

tools / options / calculation - ensure it is set to automatic.

Cheers
JulieD

 

[jeff]

Hi,

I'm sure you've checked, but do you have relative
reference, like =LEFT(A1,4); or =LEFT($A$1,4)?

The $'s will keep the same reference cell so your
copy/paste won't 'move' along with your new cells.

Otherwise, it works for me....

jeff

 

[dillonke]

Tools/Options Calculation set to automatic did the trick, thanks