View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gyzmo Gyzmo is offline
external usenet poster
 
Posts: 4
Default Why do some dates turn to ######

Thanks all three of you for the correct answer. Never gave that obvious
answer. I am copying and pasting rows from another report and I guess my
format over road theirs. Thanks again.

"Dave Peterson" wrote:

If it's a date, try widening the column or decreasing the size of the font.

Gyzmo wrote:

I use Excel to post results of training. Some entries need dates when test
was taken, but when I put in date 10/30/06 it appears as ######. How can I
get actual date to appear?


--

Dave Peterson