J joeu2004 Mar 3, 2009 #2 how can I convert date to number ? Click to expand... If you mean a "serial number", simply format the cell as Number, with zero or more decimal places depending on whether or not it is just a date.
how can I convert date to number ? Click to expand... If you mean a "serial number", simply format the cell as Number, with zero or more decimal places depending on whether or not it is just a date.
G Gord Dibben Mar 3, 2009 #3 Format as General Or post back with more details. Gord Dibben MS Excel MVP