Forum Discussion

Isabelle75017's avatar
Isabelle75017
Copper Contributor
Dec 12, 2023

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 which recognize the format of the cell and then allow me to put a minus in front of the number.

 

Thanks

excel

2 Replies

Sort By
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 12, 2023

    Isabelle75017 

    =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.

    • Isabelle75017's avatar
      Isabelle75017
      Copper Contributor
      Dec 13, 2023
      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.

Resources