Hi All

Maybe someone can give me a quick hint as to how i do something in excel (I thought this was a good place to start!)

I have to produce a spreadsheet which just has column after column of numbers from 000001 - 100000. I need to have all the zeros in front of the numbers as well but obviously when i put them it it just converts ti back to single digits and if i convert it to text, it then doesn't work if i try to use formulae to make things easier.

Can anyone help?

Thanks

Graeme