How to Convert 5-Digit Julian Dates to Regular Dates in Excel. The Julian date format is a five digit number broken into two parts: a two-digit representation of the year followed by a three-digit ...

Convert your date to hex format by dividing it by 16. To calculate the hex value of your number, you need to repeatedly divide it by 16 and multiply the remainder by 16 each time.

To convert a serial number to a date format, follow the steps below. Select the cell you want to format. On the Home tab in the Number group, click the bottom right arrow.