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
