Formatting Numbers as Text??

[jillbee]

I'm trying to figure out how to format cells in order to end up with single digit numbers with a leading zero. For example, in column A I have the number "1". In B there's "Apples". Column C is a simple formula that combines the two.

What I want to end up with in column C is "01.0 Apples", "02.0 Oranges" etc. but I can't figure out how to preserve the leading zero. I need that since ultimately these values in C are pasted into another file that's sorted alphabetically so I need to leading zero to remain for the single digit entries.

I set a custom format for column A using "00.0" but can't figure out how to get the leading zero to show in column C. Hopefully the attached explains it better than I can!

[AlKey]

Try it like this

=TEXT(A1,"00.0")&" - "&B1

[mehmetcik]

Please Login or Register  to view this content.

[sktneer]

Try this.....
In C1

Please Login or Register  to view this content.

Does this help?

[Pepe Le Mokko]

Like this =TEXT(A1,"0#0.")&"0 "&B1

[sktneer]

Three same answers in 3 minutes.
Should have been checked before posting.

[jillbee]

Try it like this

=TEXT(A1,"00.0")&" - "&B1

Excellent-- that's the ticket!

I have to say this is an incredible forum. I've come crawling in here several times with these types of questions and within MINUTES folks are able and willing to help me out. Thanks very much to all for the input!

[sktneer]

I have to say this is an incredible forum.

I agree with you.

Glad we could help and thanks for the feedback as well.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

[jillbee]

I agree with you.

Glad we could help and thanks for the feedback as well.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

Ah, right. Thanks for the reminder.