Cell Format

  • Thread starter Thread starter Angelo
  • Start date Start date
A

Angelo

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?
 
Could be you are in "Formula View"

CTRL + `(backquote) to toggle on/off


Gord Dibben MS Excel MVP
 
Back
Top