In a predesigned workbook, I was entering a date in a cell but it would
default to the general format. I tried changing the format in the cells
dialog box but it still displays as a general format. The date displays in
the formula bar as a date, but not in the cell. How do I get the cell to
display the date format that I want?