MrExcel Publishing
Your One Stop for Excel Tips & Solutions

format numbers


Posted by sam b on October 11, 2001 6:53 AM

what kind of function would I need to write
to get numbers formatted in a fixed 3 figure number.


Posted by Dan on October 11, 2001 8:05 AM

Under Format, choose Custom and type "000" (without the quotes) in the field. I think that is what you are asking?

Also - If you need to restrict data to 3 digits max, you would do that under Data -> Validation. Under "Allow" select Text Length and put 1 as minimum and 3 as maximum.

HTH