Thank you for your answer. Relating to my initial problem, what did i do
wrong?




"Dave Peterson" wrote:

With calculation set to automatic, then any cell affected by any change will be
recaculated without you doing anything (except for waiting).

If you have a giant workbook with lots of calculations that take a long time to
recalculate, then you may want to turn calculation to manual. Then you can make
your changes without having to wait for that long time.

But before you trust what's displayed, you'll want to force a recalculation --
or even turn calculation to automatic.

a-frustrated-excel-user wrote:

You are genius... follow on question, What difference does it make to set it
to Automatic ?

"Roger Govier" wrote:

Hi
Take a look at ToolsOptionsCalculation and ensure it is set to
Automatic

--
Regards

Roger Govier


"a-frustrated-excel-user"
wrote in message
...
I was trying to use LEFT to extract the first 4 digits. I used
=Left(A1,4).
It gave me 2210 for A1. However, when i drag it down to A5, it gave
me every
result as 2210. What is the problem? Thanks.

2210 - Airfare/Rail
2220 - Lodging
2230 - Ground Transportation
2240 - Meals
2250 - Entertainment





--

Dave Peterson