Thread: 00/01/1900
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
batterseamike batterseamike is offline
external usenet poster
 
Posts: 1
Default 00/01/1900

I have tried to format a column in an excel worksheet to show dates but
whatever I type in, it always shows 00/01/1900. This is happening on one
sheet only, others record what I type in without any problem but seem to be
formatted in the same way as the sheet giving wrong output. HELP, I'm going
mad trying to figure it out!