TEXT function

mcs51mc

New Member
Joined
Nov 16, 2005
Messages
22
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... ...
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

AgentSmith

Well-known Member
Joined
Mar 8, 2004
Messages
575
Why not just put the "PS" bit in directly?
=B15 & " / PS-" &TEXT(C7;"00-000")
 

mcs51mc

New Member
Joined
Nov 16, 2005
Messages
22
Because I never thought that way :oops:

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

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
mcs51mc said:
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

New Member
Joined
Nov 16, 2005
Messages
22
That's what I looked for "\" but didn't found until now().
Thanks a lot guys
 

Watch MrExcel Video

Forum statistics

Threads
1,118,535
Messages
5,572,747
Members
412,482
Latest member
arooshrana2
Top