date formated as date showing as number
 

I have a sheet that has the column formated as a date. When a date is
entered, It shows in the toolbar area as a date but it shows on the cell as a
number.

date formated as date showing as number
 

you are viewing formula mode.

go to tools | options | view tab | uncheck formulas | ok

Or

Ctrl + ~



On Oct 29, 10:53*pm, JR wrote:
I have a sheet that has the column formated as a date. When a date is
entered, It shows in the toolbar area as a date but it shows on the cell as a
number. *

date formated as date showing as number
 

Thank You Muddan - That worked. :)

"muddan madhu" wrote:

you are viewing formula mode.

go to tools | options | view tab | uncheck formulas | ok

Or

Ctrl + ~



On Oct 29, 10:53 pm, JR wrote:
I have a sheet that has the column formated as a date. When a date is
entered, It shows in the toolbar area as a date but it shows on the cell as a
number.