I have a spreadsheet where I want to format the cells as dates. However, I
need to paste dates from a word document into the cells. When I do this, the
dates do not show up as the way I formatted them. Even if I apply the date
format, the correct one does not show. Is there a way to format the pasted
cells to show the correct format?

Thanks in advance for any help.