4 quick and easy ways to convert numbers stored as text to real numbers in Excel Your email has been sent Software Installation Policy Five Methods to Insert a ...

Excel calls them serial numbers and uses them to calculate dates and times. Next, enter the following formula in column C to convert Excel’s serial-number dates to Julian dates: =RIGHT(YEAR(B1 ...