Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Promoted
Outlier
Lv 4
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!
1 Answer
Relevance
- Jorge MEXLv 64 years agoFavorite Answer
place mouse in a cell, click right button
format cells
custom
write : yyyyddmm
Still have questions? Get your answers by asking now.