Select the cell and FormatCellsNumberDate....choose a format.


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:30:03 -0800, golfdunwoody
wrote:

Help please; when I change a data style in one cell, it changes the data type
in all cells. As an example if I change one cell to a date, all the cells
convert to a date format.

Q. How do I change on cell to a different style without changing all the
cell in the worksheet to this style?