I know there's no logical reason why a 9 letter word shouldn't fit in a
column that's 9 wide. If your 9 letter word is the word September typed in
normally then it fits the column fine HOWEVER, September produced as a result
of formatting a date to show just the month (using custom format mmmm) DOES
NOT fit in a column 9 characters wide in Excel 2007. Furthermore, words such
as November and December produced as a result of the mmmm custom format
(which are both 8 characters long) DO NOT fit in a column 9 characters wide
whereas February produced as a result of the custom format mmmm (also 8
characters) DOES fit in a column 9 characters wide.

Andrea

"David Biddulph" wrote:

There is no reason why a 9 letter word should fit in a column width of 9, as
(unless you are using a fixed-width font like Courier) the letters will not
be of equal width.
In a proportional font, see how wide SSSSSSSSS is, compared with lllllllll.

See http://support.microsoft.com/kb/214123 for further explanation.
--
David Biddulph

"Andrea Jones" wrote in message
...
Sorry, don't know what I was doing there, but I'm still having a problem
which seems to be a bug. Enter the date 1 September 2007 in a cell
(01/09/2007 or 09/01/2007) and use custom format to format it as mmmm.
Write
the word September in a cell underneath and set the column width to 9 -
the
custom format cell does not fit. The dates 1/11/07 (November) and 1/12/07
(December) also don't fit but 1/2/07 (February) which is also an 8 letter
month does.

Andrea Jones

"Jim Rech" wrote:

Exactly 10 here. Try it in a new worksheet. You have to use the Normal
font name and size. Unless you've changed the default it's Calibri and
11.

--
Jim
"Andrea Jones" wrote in message
...
| In older versions of Excel you could work out the column width you
needed
by
| setting the number of characters. A date like 01/01/2008 would fit in
a
| column 10 characters wide. In Excel 2007 dates do not fit in columns
10
| characters wide, even when the font is the same as the Normal style.
|
| Does anyone have any ideas on this, looks like a bug to me?
|