Convert text numbers to number format

M

montagu

I have received a file that has a date column. However, the column is
reading as text. I need to change the column so that the date reads as
a number format. Any ideas?
 
S

scottymelloty

Right click and reformat as you want then click on cell and press F2 an
enter to refresh data that should do the tric
 
Top