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

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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
<(E-Mail Removed)> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can CVS data be converted to Access?	Jerry	Microsoft Access External Data	2	14th Nov 2008 08:34 PM
BCM Slow with converted ACT data	Cgal	Microsoft Outlook BCM	0	18th Jul 2007 06:18 PM
web data converted to Excel	=?Utf-8?B?TWVkbWFu?=	Microsoft Excel Misc	2	12th Jul 2007 12:14 AM
TEXT and Data converted to only data	aiden_dar@yahoo.com	Microsoft Excel Misc	4	1st Mar 2007 03:40 PM
CD-RW Data Converted to Read Only on XP!!!	Darkmann	Windows XP General	4	22nd Oct 2003 06:32 PM