Forum Discussion
Format indian numbers
Hi, I have some numbers coming from an indian software, the issue is tha negativ number are shaped "Cr" and not - so i am not able to make a difference between - and +. It must exist a formula w...
=SUM(NUMBERVALUE(SUBSTITUTE(A1:A2,"Cr","-")))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
Hi Olivier,
The issue is that Cr is not in the cell, it is only in the cell format, so the formula doesn't recognise it.
The issue is that Cr is not in the cell, it is only in the cell format, so the formula doesn't recognise it.