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

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.

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

Make your column wider.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"preen514" wrote:

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.

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

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

On Mon, 4 Jan 2010 12:40:01 -0800, preen514
wrote:

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.