accurate size of a number

  • Thread starter Thread starter a_d66
  • Start date Start date
A

a_d66

hello,
my problem is:
i want to add the ID numbers of people. each number sould be with 9
digits, and if someone add a shorter number, the excel has to add zeros
before the number so it will be axactly 9 digits.

for example: if I add the number 1234567 the excel will change it to
001234567.

help me please to do it, and without usint the text option. i want it
as a num options.

thanks
 
a_d66,

Interesting name you have. :-)

Format | Cells | Custom .... in the custom field "000000000" without the
quotes.

If you enter 25, you get 000000025

Hope that helps.

Regards,
Kevin
 
Back
Top