Convert excel date to a number?

I want the date to be automatically formatted to a number such as in the following example:

12/31/1993 (original date format) to 19933112

Is an automatic format possible? I have hundreds of these that need to be formatted!

Jorge MEX2017-02-18T22:26:04Z

Favorite Answer

place mouse in a cell, click right button

format cells

custom

write : yyyyddmm