Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date and number not displayed correctly
On Jan 8, 11:21*pm, md wrote:
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. What exactly do you mean by "the format of the cells is not correct"? Other than the columns being squeezed and, therefore, you might see "#" symbols, what else is wrong? What font is used? If the font is not available one system or the other, a default font will be selected, which might be wider. Another possibility is the screen resolution, I think; perhaps even aspect ratio (4:3 v. 16:9). Look at the Display control panel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date and number not displayed correctly
On Jan 9, 6:00*pm, joeu2004 wrote:
On Jan 8, 11:21*pm, md wrote: 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. What exactly do you mean by "the format of the cells is not correct"? Other than the columns being squeezed and, therefore, you might see "#" symbols, what else is wrong? What font is used? *If the font is not available one system or the other, a default font will be selected, which might be wider. Another possibility is the screen resolution, I think; perhaps even aspect ratio (4:3 v. 16:9). *Look at the Display control panel. Hi, Yes. The date is displayed as '#'. I noticed that the font for the date shows as Arial 7, while it has been set to Arial 8. And when i select the 'Format Cell' option, it displays the Custom option 'yyyy!/ mm!/dd'. It should display Date '*2001/03/01'. Thanks, Manasi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date and number not displayed correctly | Excel Discussion (Misc queries) | |||
Wrong number displayed. | Excel Discussion (Misc queries) | |||
Save as .xml not displayed correctly | Excel Discussion (Misc queries) | |||
How do i Use actual number displayed? | Excel Worksheet Functions | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions |