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.
