i am trying to fix a spreadsheet that a coworker made. it includes a formula
that subtracts one date from another. the problem is that the person put the
dates into the spreadsheet in "general" format. when i enter the formula
(which also includes a conditional), i get an error because the format of the
date is wrong. when i right click the dates and change the format to "date",
the numbers stay as they were when entered in "general" formatting, and the
only way i can get them to be correct and work with the formula is to
completely retype every single date AFTER changing the format to "date." is
there a way to make the format correct once the data is already in there
without having to retype everything?