Adding decimals to a formulation text string

Nova1979

Board Regular
Joined
Feb 4, 2020
Messages
111
Office Version
  1. 2010
Platform
  1. Windows
Hello all
Currently I am using the following formula to combine multiple cells to another sheet
=IFERROR((Repairs!B2&””&”/X/“&Repairs!C3),””)

this returns a result of FF/X/4 or FF/X/0.5 or
RU/X/10

the issue I am having is I need the result returned as follow containing 1 decimal place regardless of the amount of numbers before the decimal
FF/X/4.0
FF/X/0.5
RU/X/10.0

Can anyone please help with adjusting the formula. I have tried simple formatting without success and am unsure of how to do this

unfortunately due to circumstances I am limited to utilising formula only. Macro is not an option

thank you
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
What about: =IFERROR(Repairs!B2&""&"/X/"&TEXT(Repairs!C3,"0.0"),"")
 
Upvote 0
Hi,

You just need to add the TEXT function to the formula,
also, you have extra unnecessary quote marks, add sheet name to suit your data:

Book3.xlsx
BCDE
2FFFF/X/4.0
3FF4FF/X/0.5
4RU0.5RU/X/10.0
510
Sheet862
Cell Formulas
RangeFormula
E2:E4E2=B2&"/X/"&TEXT(C3,"0.0")
 
Upvote 0
Solution
VBA Code:
=IFERROR((CONCATENATE(Repairs!B2, "/X/", TEXT(Repairs!C3),"##0.0"),””)
 
Upvote 0
Thank you all for the extremely rapid response
I have adjusted with the text(c3,”0.0”) as applicable and it works great

thanks again
 
Upvote 0
You're welcome, thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,486
Messages
6,113,932
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top