常用日期格式转换公式

原格式2006-07-202005-06-082005-11-02原格式2006-7-202005-6-82005-11-2原格式200607202005060820051102原格式200607202005060820051102原格式2006.7.202005.6.82005.11.2原格式2006.7.202005.6.82005.11.2原格式2006.7.202005.6.82005.11.2要求修改后格式公式TEXT(A4,\"yyyymmdd\")TEXT(A5,\"yyyymmdd\")TEXT(A6,\"yyyymmdd\")公式TEXT(A7,\"yyyymmdd\")TEXT(A8,\"yyyymmdd\")TEXT(A9,\"yyyymmdd\")公式TEXT(A14,\"0000-00-00\")TEXT(A15,\"0000-00-00\")TEXT(A16,\"0000-00-00\")公式TEXT(TEXT(A19,\"0000-00-00\"),\"e-m-d\")TEXT(TEXT(A20,\"0000-00-00\"),\"e-m-d\")TEXT(TEXT(A21,\"0000-00-00\"),\"e-m-d\")公式TEXT(SUBSTITUTE(A24,\".\TEXT(SUBSTITUTE(A25,\".\TEXT(SUBSTITUTE(A26,\".\公式TEXT(SUBSTITUTE(A29,\".\TEXT(SUBSTITUTE(A30,\".\TEXT(SUBSTITUTE(A31,\".\公式SUBSTITUTE(TEXT(SUBSTITUTE(A34,\".\SUBSTITUTE(TEXT(SUBSTITUTE(A35,\".\SUBSTITUTE(TEXT(SUBSTITUTE(A36,\".\200607202005060820051102要求修改后格式200607202005060820051102要求修改后格式2006-07-202005-06-082005-11-02要求修改后格式2006-7-202005-6-82005-11-2要求修改后格式2006-07-202005-06-082005-11-02要求修改后格式2006-7-202005-6-82005-11-2要求修改后格式200607202005060820051102