Prev: TimeStamp
Next: Number format changes to date by itself
From: Bruce Sinclair on 21 Apr 2010 19:19
In article <4BCE4686.600D7C6B(a)verizonXSPAM.net>, petersod(a)verizonXSPAM.net wrote:
>Excel will still wrap text when there are no spaces in the string.

... and I just found an example of this in one of my own sheets. Doh !
What was I thinking ... maybe readability ? :)

Thanks


>Bruce Sinclair wrote:
>>
>> In article <73500491-B7D5-46E8-8F39-0C46EE670BD5(a)microsoft.com>,
> =?Utf-8?B?cG1ldG5j?= <pmetnc(a)discussions.microsoft.com> wrote:
>> >It happens on a brand-new, blank worksheet, with the text abcdefghij.
>> >
>> >Try this:
>> >-open a blank sheet
>> >-type in abcdefghij in A1 (or basically any text that's wider than the
>> >current cell width)
>> >-turn Wrap Text on
>> >-format the cell with the @*. custom format
>> >-see ########
>>
>> I'd suggest that xl can't wrap your text as there is no space in it to break
>> the text up. Basically, if one word is wider than your column, then you are
>> out of luck. The fix ? ... either set the column width a bit larger or
>> change your text. :)
>>
>> HTH
>
First  |  Prev  | 
Pages: 1 2 3 4
Prev: TimeStamp
Next: Number format changes to date by itself