Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== Excel Text Generating Format ====== * text cell combine: <code>="preText"&A1&B1&C1&"endText"</code> ====== Excel formulas====== * Date minus Date gets days (A1 as fixed date; A2 as date to compare)<code>=DATEDIF(A2,$A$1,"d")</code> * today's date<code>=TODAY()</code> ====== Excel shortcuts ====== Data insert ^ctrl+; | insert date| ^ctrl+shift+; | insert time | ====== Excel Data Creation ====== ===== excel to xml ===== appwiki/excel.txt Last modified: 2021/08/28 08:26by ying