How to get leading 0's to work in formula?

[brusk]

I have a table with numbers in it no larger than 15. I'm doing a VLOOKUP on the table to pull a number that I use in a formula that does a CONCATENATE"SERVER #" plus the VLOOKUP vlaue. I then sort the colum in order by these server #'s. How can I get it to convert or read these numbers in as a forced 2 digit number so after the sort it doesn't list 1,10,11,12,13,14,15,2,3,4,5,6,7,8,9 as that's not really doing what I'm trying to pull off.

[hoffey]

Try this:

Please Login or Register  to view this content.

[e_lad]

Not sure I understood what you're trying to achieve but...

Try to custom format the numbers as 0#. This would force the leading 0 followed by the number and it should work with sorting this the number column which would in turn sort the desired text column.

Hope this helps

[brusk]

Try this:

Please Login or Register  to view this content.

Didn't know about that one. Also found this, will also use I4 for example.

=CONCATENATE("server # ", TEXT(I4,"00"))


Thanks for the help.