How to convert numbers in excel format
Users questions: I first entered in the format of 2000.01, now converted to 2000-01, what is the how, thanks to work because there are more than 200 years to be converted all over, each person's time is different, which I replaced with a to "." replaced "-", but was unsuccessful. 77 7777: 1, select A1, "2000.01." 2, "* Edit * Replace Find what Replace *-* *.* Replace All", the results in C1. 3, select C1, "format * digital * cell * classified * custom * type * YYYY-MM * OK ", the effect Such as E1. Appendix: Conversion format. Xls