PDA

View Full Version : Solved: excel can't calculate formula



neditheg
06-08-2012, 06:17 AM
so I have an excel file with 39000 rows.
I want to add 39 before the phone number.
I'm using ="39"&g2 but .. I'm getting always the first phone value with 39 before. I don't understand why.

"Results of formula may be out of date because Excel is not set to calculat automatically".

What I should do to solve this!?

thanks!

neditheg
06-08-2012, 06:20 AM
I'll attach an example

VoG
06-08-2012, 06:21 AM
In Excel options set calculation to Automatic or press F9 to force a recalculation.

neditheg
06-08-2012, 06:22 AM
done!

neditheg
06-08-2012, 06:24 AM
hugh! Thanks! :)