Excel 2007: @*. formatting
in [General]
|
Prev: TimeStamp
Next: Number format changes to date by itself
From: pmetnc on 19 Apr 2010 16:36 Is there any way to make this format work with Wrap Text turned on? Whenever the text is wide enough to need to be wrapped, I always get #######################.
From: EricG on 19 Apr 2010 17:48 Try changing the format of the cell from Text to General. Eric "pmetnc" wrote: > Is there any way to make this format work with Wrap Text turned on? Whenever > the text is wide enough to need to be wrapped, I always get > #######################.
From: Dave Peterson on 19 Apr 2010 19:05 I think you're out of luck. I couldn't do it (well, in xl2003). If that string is between 255 and 1024 characters, then I get the ### symbols. It's not really the line wrapping that's causing the trouble. pmetnc wrote: > > Is there any way to make this format work with Wrap Text turned on? Whenever > the text is wide enough to need to be wrapped, I always get > #######################. -- Dave Peterson
From: Dave Peterson on 19 Apr 2010 19:11 ps. Have you thought of using a table in MSWord? They have this kind of leader for tabs (I think) and I think that you could do this kind of thing with trailers, too. (But I haven't used this feature in a long time.) pmetnc wrote: > > Is there any way to make this format work with Wrap Text turned on? Whenever > the text is wide enough to need to be wrapped, I always get > #######################. -- Dave Peterson
From: pmetnc on 20 Apr 2010 08:48
How does that help when trying to use a custom format? "EricG" wrote: > Try changing the format of the cell from Text to General. > > Eric > > "pmetnc" wrote: > > > Is there any way to make this format work with Wrap Text turned on? Whenever > > the text is wide enough to need to be wrapped, I always get > > #######################. |