Need help

[Ron99]

Hi,

I have codes in column A

example - GS023156

I have list of codes in column A, in column B, I am using substitute formula to remove the word GS, =SUBSTITUTE(A2,"GS","") , formula works perfectly fine, but the problem is when the double click or drag down the formula its just copying the same numbers, but if I go to the next cell hit F2 and enter the formula works fine, is there any problem with excel setting.

Regards,
Ron...

 

[VoG]

Tools > Options > Calculation tab. Make sure that calculation is set to Automatic.

 

[Ron99]

Thank you..that was quick, it works fine now.