On Thu, 15 Sep 2011 00:45:51 +0100, Colin Hayes wrote:



Hi All

I have a small problem.

I column A I have a row of cells , some of which have numbers , some of
which are empty.

The numbers usually have 12 or 13 chars.

Some have fewer than 12 chars. I need to make these up to 12 chars by
placing zeros at the start of each.

Cells with numbers already at 12 or 13 chars , or which are blank should
remain unaltered.


Can someone help with a formula to achieve this?

Thanks. Grateful for any advice.


You can custom format the cells: Type: 000000000000 (That's 12 0's)