3

I'm using Microsoft 365's Excel on Windows 7. I'm trying to understand why this formula:

="S/ "&ROUND(SUM(E39:E40),2)

Will not provide an output to 2 decimal places? My intention is to concatenate "S/", the local currency, to the numerical string. The range of cells used are formatted as number to 2 d.p.

I can achieve the intended result by formatting the output cell to the currency in question. But why won't it work using ampersand?

Any clarification most welcome.

Albert F D
  • 135

1 Answers1

5

Try using the TEXT() function instead:

="S/ "&TEXT(ROUND(SUM(E39:E40),2),"0.00")

or,

="S/ "&TEXT(SUM(E39:E40),"0.00")

Using just & won't preserve the formatting you are looking therefore using the TEXT() function just does the requisite !

Mayukh Bhattacharya
  • 4,486