Display SAP Minus keyfigures correct in Excel

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

Excel minus figures display
Excel minus figures display

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:

 

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

Write a comment

Comments: 0