#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 390
Default Get #### when typing

When typing a lengthy statement in a cell I get ######. Is there a character
limitation in Excel 2007 and is there a work around to this?

Thank you

Bill
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Get #### when typing

Try formatting the cell as General.

Excel has a display problem with strings between 255 and 1024 characters in
cells formatted as text.

Bill wrote:

When typing a lengthy statement in a cell I get ######. Is there a character
limitation in Excel 2007 and is there a work around to this?

Thank you

Bill


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default Get #### when typing

Try to make the cell/column wider and/or try to format it as "Wrapping text"
Micky


"Bill" wrote:

When typing a lengthy statement in a cell I get ######. Is there a character
limitation in Excel 2007 and is there a work around to this?

Thank you

Bill

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where has my typing bar gone? gramsiam65 Setting up and Configuration of Excel 3 April 7th 23 12:17 PM
name typing Vicky Excel Worksheet Functions 2 April 20th 08 01:00 PM
Typing problem GY Fong Excel Worksheet Functions 3 July 13th 07 07:42 AM
vertical typing? Greg Excel Discussion (Misc queries) 3 April 27th 07 08:14 PM
typing #1 becomes #10 tenbobblind Excel Discussion (Misc queries) 3 March 2nd 07 02:03 PM


All times are GMT +1. The time now is 05:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"