How to pick a biggest data from a group of data?

Y

yoyo2000

Thanks,I meet another question:

I have some data with a date in he format below

03/11/1998
03/12/1998
03/13/1998
03/16/1998

I want to convert them into

19980311
19980312
19980313
19980316

I tried to set the cell property,but it didn't work.
Could you please help to give me a formular to do so?
Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to sum data from a data range 3
Conditional Formatting Quartely Months 2
KPI Data Chart Display 1
time_report_date-wise_employee-wise 6
How to pick a biggest data from a group of data? 2
Splitting data in a cell 1
Splitting data in a cell 2
Specific Date from a Range 3

Top