How can I start a number in a cell with a 0 EG 012678
G Guest Aug 11, 2004 #2 Hi If you need to keep the cell as a number - so you can do calculations on it - you could use a custom format like 000000. If you don't need it to retain its maths ability, use an apostrophe ' first (ie '012678)
Hi If you need to keep the cell as a number - so you can do calculations on it - you could use a custom format like 000000. If you don't need it to retain its maths ability, use an apostrophe ' first (ie '012678)
