All data is converted to #####. Why?

  • Thread starter Thread starter preen514
  • Start date Start date
P

preen514

I was using an Excel spreadsheet just fine until I hit a few keys (I'm not
sure what). Now, when I type in any data, as soon as I click in another area,
the data is converted to #####. Is this an option I can turn off? Thanks.
 
If the data are numbers, simply widen the column.

If the date are long text strings, re-format the cells as General


Gord Dibben MS Excel MVP
 
Back
Top