I copy a word form (cntrl A then cntrl C), which contains a date in the
document, and paste (CNTL V) into an excel worksheet. In an another
worksheet within that same file I have set a formula which will tell me what
day of the week that date is. But it comes back with a "#value" error. I
can fix it by manually re-typing the exact information into the box and then
it recognizes it and returns the desired day. The formula is
"=TEXT(WEEKDAY(K32), "dddd")" where K32 equals the cell in the other
worksheet, within the file. Sounds confusing when I try to type out the
explanation. But I think I've reproted accurately. Hope someone can help.