On Jan 11, 10:39*am, Dave Peterson wrote:
If you widen the column, what do you see?

Changing book.xlt won't have any effect on any other workbook.





wrote:

On Jan 11, 10:20 am, Dave Peterson wrote:
What is the format for the short date in the windows regional settings?

Is one mm/dd/yy and the other m/d/yy or mm/dd/yyyy?

md wrote:

hi,

I am having a problem with excel. when i open a file the date and numbers
are not displayed correctly since the columns are getting squeezed and the
format of the cells is not correct.

when i open the same report on a different system the data is displayed
correctly.

i think there could be some change in the regional settings in the two
systems. i tried to change the setting but it does not help.

can you please help??

--

Dave Peterson

hi Dave,

i verified that earlier. both are set to 'yyyy/mm/dd'. I even tried to
change the Book.xlt, the template. But nothing seems to work.

M

--

Dave Peterson- Hide quoted text -

- Show quoted text -

When i widen the column i see the date correctly. the font is
displayed as arial 7. while in the original report it is set to arial
8.