Formula To Display Numbers In Custom Format

[saied]

hi i use this formoula =IF(LEN(A1)=1;"00"&A1;IF(LEN(A1)=2;"0"&A1;IF(LEN(A1)=3;(A1)))) but when i have negative number the result is not correct you can see the example below
116 79 92 143 223 -18 -2
result

116 079 092 143 223 -18 0-2

desirable:

116 079 092 143 223 -018 -002

[Admin]

Hi

Welcome to board!!

You can custom format the cell itself. Right click on cell > format cells > Click custom on category and in type: 000 > OK

or use this formula.

=TEXT(A1;"000")