====== Excel Text Generating Format ====== * text cell combine: ="preText"&A1&B1&C1&"endText" ====== Excel formulas====== * Date minus Date gets days (A1 as fixed date; A2 as date to compare)=DATEDIF(A2,$A$1,"d") * today's date=TODAY() ====== Excel shortcuts ====== Data insert ^ctrl+; | insert date| ^ctrl+shift+; | insert time | ====== Excel Data Creation ====== ===== excel to xml =====