Excel Formatting

  RWM 16:49 05 Mar 05
Locked

I have a spreadsheet that has accidentally had the whole sheet formatted to Text. Everytime I try to enter a formula it appears as a text entry. Despite trying to change the format or delete the column the formula remains showing as a text entry.

Does anyone know of a way around this short of copying everthing to a new sheet and starting again.

The version of Excel I am using is 2000.

  VoG II 16:53 05 Mar 05

.

Tools/Options, View tab, untick Formulas.

This thread is now locked and can not be replied to.

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

1995-2015: How technology has changed the world in 20 years

How to create an introvert-friendly workplace

Apple Watch Series 2 review | Apple Watch 2 review: New Apple Watch is faster, brighter,…