Tuesday, May 20, 2014

Special Type in Excel

1, Starting from 0 : use ' type.

2, Office button / Excel Options / Formulas / Uncheck “Numbers formatted as text …”




after unchecked "numbers formatted as text...."

  More Format Numbers / Custom / "7187621900"@ or (718) ###-####



No comments:

Post a Comment