Display SAP Minus keyfigures correct in Excel

Unfortunately, SAP export negative numbers like "Number-":

So you can work with this numbers, they must be changed to the format "-Number". This can be done either by hand, which is very elaborate for a large list or you can use the following Excel formula:

1

=MAX(C1;-SUBSTITUTE(C1;"-";""))

These posts might also be interesting:

• Sum many ranges with ALT=
• One further Excel Dashboard Example
• Create simple Excel Dashboards
• Create own Excel formula

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.