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?

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?
|

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?
|

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?
|

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?
|

You misread my message. I said "There is no reason why a 9 letter word
*should* fit in a column width of 9".
Read the rest of what I said.
--
David Biddulph

"Andrea Jones" wrote in message
...
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?
|