Formula to add tille?

[Bailey031285]

I need to take a # like 55 and have it reproduce '0055 . I have some examples where I do not need the leading zeros but if there is not 4 numerical characters I need zeros as fillers. Any help would be greatly appreciated.

[NBVC]

Format the cells as Custom (from Number tab) and enter: 0000

[Bailey031285]

For some reason that did not work I think I need a formula that makes it look like it a number as a text where it has the green triangle in the left hand corner?

[savio21]

Select your cell go to Formats > Custom > enter 0000

If the cell you've just formated is a formula referncing another cell you have formatted to text it wont work.

[NBVC]

If you want a formula and the original number is in A1, then in another cell.

=TEXT(A1,"0000")