Excel Formatting

  RWM 16:49 05 Mar 2005
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 2005

.

Tools/Options, View tab, untick Formulas.

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires