New columns won't calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've been sent a spreadsheet which doesn't appear to be locked or protected,
in that it is possible to edit data and to add and delete columns. Formulae
are calculating normally in existing columns, but when I added a new column
and entered a formula, it showed the formula rather than the result. If
anyone has any idea what might cause this to happen and how it can be
prevented advice would be most appreciated!
Thanks!
 
Hi

It sounds as though those extra columns have been pre-formatted as text.
Mark the columns>Format>General
Then when you enter your formulae, they should work.
 
Thank you, that's exactly it and very helpful!

Roger Govier said:
Hi

It sounds as though those extra columns have been pre-formatted as text.
Mark the columns>Format>General
Then when you enter your formulae, they should work.
Click to expand...
 
Back
Top