A Arvi Laanemets Oct 22, 2003 #2 Hi When you want that it remains a number, then format the cell as Custom="00000" Arvi Laanemets
K KPO Oct 22, 2003 #3 -----Original Message----- How do I format a number with leading zeros? Eg:00010 Many Thanks Richard . An apostrophe ahead of the leading zeros will also work Click to expand... ie '0000010 ,without going to custom format
-----Original Message----- How do I format a number with leading zeros? Eg:00010 Many Thanks Richard . An apostrophe ahead of the leading zeros will also work Click to expand... ie '0000010 ,without going to custom format
W Werner Flamme Oct 23, 2003 #4 KPO schrieb am 22.10.2003 16:56: ie '0000010 ,without going to custom format Click to expand... Yes, but doing so will convert all numbers into text, so you can't do calculations with them.
KPO schrieb am 22.10.2003 16:56: ie '0000010 ,without going to custom format Click to expand... Yes, but doing so will convert all numbers into text, so you can't do calculations with them.
