Formats with multiple leading 000s need to preserve these in the output: console.log(SSF.format('000.0', 1)) 1.0 (Excel gives 001.0) console.log(SSF.format('000.#', 1)) 1. (Excel gives 001.) console.log(SSF.format('000.0', 1.2)) 1.2 (Excel gives 001.2) console.log(SSF.format('000.#', 1.2)) 1.2 (Excel gives 001.2)