View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Date and number not displayed correctly

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