exceltoxl.com

Hi 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

Excel Array's Week

Be Simple and Be Strong like IFERROR

Crack Formula Errors

Formulas Cheat Sheet

Thanks,