Menu

Excel 2007: @*. formatting

Search this Thread

Prev

Previous Post

Next Post

Next

#15

Report Post

Posted to microsoft.public.excel.misc

Bruce Sinclair Bruce Sinclair is offline

Bruce Sinclair is offline

external usenet poster

Posts: 169

Default

Excel 2007: @*. formatting

In article , 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 ,
?B?cG1ldG5j?= 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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Formatting in Excel 2007	Jennifer[_2_]	New Users to Excel	1	November 3rd 09 08:02 PM
Formatting in Excel 2007	Griffen	Excel Discussion (Misc queries)	1	November 11th 08 08:36 AM
Formatting in Excel 2007	IVCC	Excel Discussion (Misc queries)	0	June 10th 08 02:54 PM
Formatting in Excel 2007	pcor	New Users to Excel	3	November 21st 07 03:32 AM
Excel 2007 Formatting	Sue T	Excel Discussion (Misc queries)	7	July 31st 07 10:00 PM

All times are GMT +1. The time now is 12:00 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement