is there a way for me to refresh multiple cells that has data in it? Right now, I am only able to go to each cell and press F2 and than enter.

The reason is because when I imported a file, the cells with the dates has the mm/dd/yy format and when i go into that cell and press F2 and enter, it changes to mm/dd/yyyy format.

I will need the mm/dd/yyyy format so in the next column i can put a custom format that will say "Monday".

Please let me know,thank you.