View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default Dates and Column Widths in Excel 2007

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