Forum Discussion

Messier1983's avatar
Messier1983
Copper Contributor
Dec 14, 2021
Solved

Help with error im new to excel formulas

Im using the TEXT and concatenate formula, what id like to do is in TEST 2 workbook enter £5.00 and this appear in Test 1 workbook as £5.00 Test Paid. The formula to make £5.00 successfully is  =TE...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Dec 14, 2021

    Messier1983 Try this:

    ="Test Paid: " & TEXT('[Test 2.xlsx]Sheet1'!C3, "£#,##0.00_);(£#.##0.00)")

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 14, 2021

Messier1983 Try this:

="Test Paid: " & TEXT('[Test 2.xlsx]Sheet1'!C3, "£#,##0.00_);(£#.##0.00)")

 

Messier1983's avatar
Messier1983
Copper Contributor
Dec 14, 2021
Thats worked ........Fantastic, thank you 🙂

Resources