When you say the data appears as you highlight the cell, does it appear in
the cell or just the formula bar?

Has the color of the font been changed to white for all the cells?

"jez35000" wrote:

All my data from 2 spreadsheets has disappeared overnight. Formulas, dates
etc appear as individual cells are highlighted. New typing appears in
formula bar but not in cell.
Help please.