PC Review


Reply
Thread Tools Rate Thread

####### in Cell

 
 
PSULionRP
Guest
Posts: n/a
 
      25th Nov 2009
I am typing text in a cell and then I get to a point and it just turns it to
a bunch of # signs...#####################

Why is that happening???

Thanks in advance for your review and hopeful for a reply.

PSULionRP
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      25th Nov 2009
Format the cell as General (or anything but Text) and reenter the value (F2
followed by Enter should be enough).

Excel has trouble strings between 256 and 1024 characters in cells formatted as
Text.

PSULionRP wrote:
>
> I am typing text in a cell and then I get to a point and it just turns it to
> a bunch of # signs...#####################
>
> Why is that happening???
>
> Thanks in advance for your review and hopeful for a reply.
>
> PSULionRP


--

Dave Peterson
 
Reply With Quote
 
Luke M
Guest
Posts: n/a
 
      25th Nov 2009
Increase your column width.
--
Best Regards,

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


"PSULionRP" wrote:

> I am typing text in a cell and then I get to a point and it just turns it to
> a bunch of # signs...#####################
>
> Why is that happening???
>
> Thanks in advance for your review and hopeful for a reply.
>
> PSULionRP

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options Yuvraj Microsoft Excel Misc 0 29th Jun 2009 11:20 AM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 tviola@wi.rr.com Microsoft Excel Programming 1 21st Aug 2008 10:13 PM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 tviola@wi.rr.com Microsoft Excel Worksheet Functions 0 21st Aug 2008 08:44 PM
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON CAPTGNVR Microsoft Excel Programming 2 8th Jul 2007 04:18 PM
How to create/run "cell A equals Cell B put Cell C info in Cell D =?Utf-8?B?YWJtYjE2MQ==?= Microsoft Excel Misc 5 26th Jan 2006 06:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:57 AM.