Thread: date entry
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mags Mags is offline
external usenet poster
 
Posts: 11
Default date entry

I have a spreadsheet that I use as a rooming list for a hotel. I have dates
of arrival and departure on it. ex 2/7/07. When I try to copy some date
with the dates to a new spreadsheet the date changes to something like
2/3/03. It changes the year and the date. What do to fix that?
--
mags