Format the cell with a custom format such as

00000000

(this would put enough leading zeroes in front of the number to make it up
to 8 digits).

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"caroline argyle" wrote:

I would like to display a number with leading zeros in front of it.