data into cells
 

I need help please to type data into cell and not have it come up as ### as
it has been doing. Tried formatting for wrap. Tried expanding the column.
This is just one cell in a spreadsheet that is not working right. Help
please.
--
Thanks for any help you can give me.

data into cells
 

The cause could be a bit of rogue formatting. Copy from a cell which should
have the same formatting and click on <Paste Special<Formats. It would be
nice to know how something like this happens so we don't do it again but
often this takes longer than a quick fix.

Regards.

Bill Ridgeway
Computer Solutions

"Gerrie" wrote in message
...
I need help please to type data into cell and not have it come up as ### as
it has been doing. Tried formatting for wrap. Tried expanding the
column.
This is just one cell in a spreadsheet that is not working right. Help
please.
--
Thanks for any help you can give me.

data into cells
 

What are you putting in to that cell?

try and copy a blank cell and past specialformat in the cell you want to
change. Then re-enter your data There might be some other formatting on
that cell and this should get rid of it.

--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Gerrie" wrote:

I need help please to type data into cell and not have it come up as ### as
it has been doing. Tried formatting for wrap. Tried expanding the column.
This is just one cell in a spreadsheet that is not working right. Help
please.
--
Thanks for any help you can give me.

data into cells
 

Thanks for your help. I received a note from Microsoft on this and they told
me to format the comments cells to 'general' because if you use 'text' and
have a lot of characters, it won't work. I did this and it works. I had
already tried your suggestion and it did not help. I suspect the problem
lies in the fact that my comments in this particular cell were extensive.
But the 'general' formatting works fine ... so far.
--
Thanks for any help you can give me.


"Bill Ridgeway" wrote:

The cause could be a bit of rogue formatting. Copy from a cell which should
have the same formatting and click on <Paste Special<Formats. It would be
nice to know how something like this happens so we don't do it again but
often this takes longer than a quick fix.

Regards.

Bill Ridgeway
Computer Solutions

"Gerrie" wrote in message
...
I need help please to type data into cell and not have it come up as ### as
it has been doing. Tried formatting for wrap. Tried expanding the
column.
This is just one cell in a spreadsheet that is not working right. Help
please.
--
Thanks for any help you can give me.

data into cells
 

Gerrie

Excel has a problem with text-formatted cells if they contain between 255 and
1024 characters.

Changing the format to General seems to ne the only way to get rid of the
##########'s


Gord Dibben MS Excel MVP

On Wed, 14 Mar 2007 09:48:13 -0700, Gerrie
wrote:

Thanks for your help. I received a note from Microsoft on this and they told
me to format the comments cells to 'general' because if you use 'text' and
have a lot of characters, it won't work. I did this and it works. I had
already tried your suggestion and it did not help. I suspect the problem
lies in the fact that my comments in this particular cell were extensive.
But the 'general' formatting works fine ... so far.

data into cells
 

Thanks. I had gotten an email from Microsoft on this. They advised that the
cell needs to be formatted as "general" when you are trying to enter a large
amount of text. They advised 'text' formatting will not work, but 'general'
will. I used 'general' and it seems to be working. Thank you though for
your input.
--



"John" wrote:

What are you putting in to that cell?

try and copy a blank cell and past specialformat in the cell you want to
change. Then re-enter your data There might be some other formatting on
that cell and this should get rid of it.

--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Gerrie" wrote:

I need help please to type data into cell and not have it come up as ### as
it has been doing. Tried formatting for wrap. Tried expanding the column.
This is just one cell in a spreadsheet that is not working right. Help
please.
--
Thanks for any help you can give me.