TEXT function

[mcs51mc]

Why is =B15 & " / " &TEXT(C7;"PA-00-000") working
and =B15 & " / " &TEXT(C7;"PS-00-000") not??

I want to concatenate to contents of cell B15 with the formatted contents of cell C7.
If B15 contains "ABC" and C7 contains the number 25 I need to see "ABC / PS-00-025" in the cell with the formula.

Thanks a lot for any reaction... ...

 

[AgentSmith]

Why not just put the "PS" bit in directly?
=B15 & " / PS-" &TEXT(C7;"00-000")

 

[mcs51mc]

Because I never thought that way

It works, that's all I need, thanks a lot AgentSmith

 

[barry houdini]

Why is =B15 & " / " &TEXT(C7;"PA-00-000") working
and =B15 & " / " &TEXT(C7;"PS-00-000") not??

because if you have S in the format excel treats that as "seconds", use AgentSmith's suggestion or amend to

B15 & " / " &TEXT(C7;"P\S-00-000")

 

[mcs51mc]

That's what I looked for "\" but didn't found until now().
Thanks a lot guys