Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
All data is converted to #####. Why?
0 views
Skip to first unread message
preen514
Jan 4, 2010, 3:40:01 PM1/4/10
to
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.
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.
Luke M
Jan 4, 2010, 3:59:01 PM1/4/10
to
Make your column wider.
--
Best Regards,
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
Gord Dibben
Jan 4, 2010, 4:00:28 PM1/4/10
to
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
0 new messages