爱魔域

=text(a1,"000")

????

Johnny Naperville wrote:
>
> Format(<cell>,"000") will also work.
>
> "Cervantes" wrote:
>
> >
> > I'm making a ranking list in excel and now i want all numbers to be
> > alligned when I copy them to a forum. In order to do that I need excel
> > to make every number 3 figures, so for instance 1 becomes 001 and 85
> > becomes 085. There must be a way to do this automatically in excel,
> > but how? Does anyone know?
> >
> > Thanks in advance,
> >
> > Cervantes
> >
> >
> > --
> > Cervantes
> > ------------------------------------------------------------------------
> > Cervantes's Profile: &userid=26323
> > View this thread: =483188
> >
> >

--

Dave Peterson