« Download large free stuff from here | 120 + Excel websites on net » |
Convert Number to Date Format
excel_usage, Excel TipsHi there,
Here, I am going to tell you a simple trick but highly used by our reporting folks. Especially, while extracting dates using VLOOKUP function there are many dates which formats as general rather date. It is very difficult to change the values to dates manually while large amount of data.
To avoid such instances, here is a trick which can be done before brushing your teeth.
...
Say you have extracted the dates using VLOOKUP and found the date in a general format as 41835. So to convert from this number to date, use a formula called TEXT.
=TEXT(41835,"mm/dd/yyyy")
That's it. Magic works.
Download working file.xls from here.
DO YOU USE TEXT FUNCTION?
If you have used this trick in your work, please share your experience using TEXT function. If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog and be a first among your friends who share good information.
Want to support me REGISTER here for free.
SOME IMPORTANT LINKS:
Learn Information Functions in One GO
Be Simple and Be Strong like IFERROR
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments