Convert serial number to date format excel

Bruinvis Zr. Bruinvis 44 7 7 bronze badges. This worked for me because sometimes the field was a numeric to get the time portion. V31 7, 3 3 gold badges 24 24 silver badges 44 44 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks.

Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. See more linked questions. Related Hot Network Questions. If you want to have a free trial day of this utility, please click to download it , and then go to apply the operation according above steps.

Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you.

We provide tips, how to guide and also provide Excel solutions to your business problems. I earn a small commission if you buy any products using my affiliate links to Amazon. Contact Privacy Policy. Maruf Islam Jan 9, 0. Suppose, in a dataset, we have serial numbers similar to the image below. Table of Contents hide. Dataset for Download. Further Readings:. Convert Serial Number to Date in Excel. Save Saved Removed 0. Maruf Islam. Related Articles. Added to wishlist Removed from wishlist 0.

We will be happy to hear your thoughts. Leave a reply Cancel reply. About ExcelDemy. Search in ExcelDemy. Here I have a kind add-in—Kutools for Excel introduce to you, its Convert to Date utility can do you a favor. Now the dates have been converted to standard date format. Note: The other languages of the website are Google-translated.

Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account.