View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Dates won't show?

Maybe you're looking at formulas?

Do you see the date in the formulabar and some number in the cell?

If yes, try:
tools|options|view tab|uncheck Formulas

ctrl-` (control-backquote to the left of the 1/! key on my USA keyboard) is the
shortcut toggle for this.



Riptide wrote:

I enter a date and instead a get a number that doesn't seem to correspond
with the date. The cells are all formatted for the date function, but it
still won't show the date.


--

Dave Peterson