Left function

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

Any ideas appreciated


---
Message posted from http://www.ExcelForum.com/

Hi

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

Cheers
JulieD

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

Any ideas appreciated


---
Message posted from http://www.ExcelForum.com/

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
-----Original Message-----
Hi,
I'm moved from Excel 2000 to 2003 and now I find that
the Left and
Right functions are not working correctly. They work OK
if I type them
in one cell at a time but if I use copy/paste it just
reproduces the
same result in every cell. This happens even if I use
paste
special/values as well!

Any ideas appreciated


---
Message posted from http://www.ExcelForum.com/

.

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


---
Message posted from http://www.ExcelForum.com/