Eliminating Zero before the decimal point

[Gusnk]

Experts -

I have an issue with eliminating the zero before the decimal point. I tried a number of different solutions, but nothing worked. Here is what I am trying to accomplish.

I have 3 cell with data as follows (the data is a result of a division application):
A3 .265
B3 .299
C3 .403
I want to combined them so the result appears in one cell like this: .265/.299/.403
Unfortunately for me all my different ties resulted ended up like this: 0.265/0.299/0.403

Is there a way to get the result I am looking for?

I appreciate all the help you have to offer and I thank you in advance.
Gus

 

[JimM]

Try

=SUBSTITUTE(A3 & "/" &B3 & "/" &C3,"0.",".")

 

[Gusnk]

Jim -

Works like a charm, thanks very must, I do appreciate your help.

Best regards,
Gus

 

[Gusnk]

Experts -

After receiving help with a formula from Jim, I came across another issue.

If any of the cells has an ending zero:
A3 .260
B3 .290
C3 .403

It would appear as .26/.29/.403 instead of the intended look of .260/.290/.403

Is there any way to keep the last digit (0) from being removed?

Thanks in advance for the help, I do appreciate it.
Gus

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.
Thanks

 

[Joe4]

Is that what you are looking for?

=TEXT(A3,".000") & "/" & TEXT(B3,".000") & "/" & TEXT(C3,".000")

Note that if you answer Fluff's question, he may be able to give you a sleeker solution!

 

[Gusnk]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.
Thanks

Fluff -

Thanks for the heads up, did not realize I had enter that info in profile.

Window 10 Excel 365

Regards,
Gus

 

[Fluff]

Thanks for that, it saves members asking you all the time.
How about
=TEXTJOIN("/",,TEXT(A3:C3,".000"))

 

[Gusnk]

Is that what you are looking for?

=TEXT(A3,".000") & "/" & TEXT(B3,".000") & "/" & TEXT(C3,".000")

Note that if you answer Fluff's question, he may be able to give you a sleeker solution!

Joe -

Appreciate the help, the formula did work.

If there is a sleeker solution I would appreciate it, if not thank you all for your assistance.

Best Regards,
Gus

 

[Gusnk]

Thanks for that, it saves members asking you all the time.
How about
=TEXTJOIN("/",,TEXT(A3:C3,".000"))

Fluff -

Thanks, that works as well and I appreciate it.

Again, I want to thank all who helped me with this issue.

Best regards,
Gus