aranging numbers from one cell or three cells to one cell in numerical order

[othniel]

I have 290 in a cell i would like a formula that would rearrage that in numerical order as 029. I also have 2 9 0 in separate columns and would like to arrange it in numerical order in one cell.

[dredwolf]

For the second question (this assumes the 3 cells are in A1-C1, change the references if needed):
=SMALL(A1:C1,1)&SMALL(A1:C1,2)&SMALL(A1:C1,3)

working on the first question

[othniel]

this helps a bit thank you. There is one challenge when i put it in my spreadsheet it comes up as #num, maybe because i have extracted the numbers in the colums from someplace else. It would be great if you found an answer to the first. Nevertheless, I will try to get it to work trying some other things to have the number appear.

[dredwolf]

the only reason I can see a #NUM error coming up is a zero is an "o" or "O" instead of a zero "0",this is why early programming languages made "0" with a slash through it, it made the "O" and the "0" different enought to VISUALLY notice....other likely culprits may be "l" instead of '1","B" instead of '8',leading/trailing spaces(use trim(ref) to get rid of those)...etc...also, if the values are TEXT, rather than NUMBERS, you may run into that problem...the way around that is wrap the reference in the VALUE() function (ie.. =....VALUE(A1).....)