Custom Formatting of Numbers in a cel

[music_al]

Id like to format a cell that is the result of two other cells. There should always be 5 digits to the left of the / and 2 digits to the right of the / .


Cell1 Cell2 Cell3 (Result)
1234 1 01234/01
34567 2 34567/02


Thank you in advance

Al

 

[JazzSP8]

Does this work for you?

=TEXT(A1,"00000")&"/"&TEXT(B1,"00")

 

[music_al]

Hi Jazz

Sadly not, I need that number string to be a continuous string

 

[nikio8]

=TEXT([B]RIGHT[/B](A3,5),"00000")&"/"&TEXT([B]LEFT[/B](B3,2),"00")

Very nice, I did not know this was possible Jazz

 

[Rick Rothstein]

Sadly not, I need that number string to be a continuous string

Isn't that what Jazz's formula outputs for you?

 

[music_al]

No as I need the user to enter it as a continuous string of digits

 

[Scott Huish]

No as I need the user to enter it as a continuous string of digits

But you said it was the result of 2 cells, not 1.

How is this not what you want?

Excel 2010
	A	B	C
1	1234	1	01234/01
2	34567	2	34567/02
Sheet1

Cell Formulas
Range	Formula
C1	=TEXT(A1,"00000")&"/"&TEXT(B1,"00")
C2	=TEXT(A2,"00000")&"/"&TEXT(B2,"00")