Formatting cells

[Rodney Kelly]

When I try to format dates, not all the cells format in
the same manner. As a result, plotting the data set using
the x axis as the date the graph is wrong. How do I format
all the cells the same way, I even went in and manually
changed all the cells to the same format to no avail.

Please advise..

 

[Lance]

Try setting your format on the x axis instead of the
spreadsheet. Right click on the x axis, select format
axis, select the number tab and set your date format
there.

Lance

 

[Jason Morin]

You cannot actually change the contents of a cell by
re-formatting it. It sounds like all your dates are not
really dates as Excel would interpret them. Some may be
text. To test it, use the =ISTEXT(A1) as an example on each
cell. Anything marked TRUE is not a true date per Excel.

HTH
Jason
Atlanta, GA