Move the minus sign from the end to the beginning

Number & Date > Move minus sign from back to front (e.g. 47- to -47)

This utility corrects numbers that have a finite minus for negative numbers.

For example, a number like "47-" will be converted to "-47", so this is a number that LO Calc recognizes and that you can use in your calculations.

This utility is particularly useful when you need to deal with certain imported text files, as some (financial) systems display negative numbers with a minus sign at the end.

Screenshot

After application:

Launch this tool

Click YLC Utilities > Number & Date > Move minus sign from back to front (e.g. 47- to -47) :

Do you recognize any of these situations?

• I downloaded a report that shows the following negative numbers: 123.25– . How can I make the negative sign appear to the left?
• When using copy and paste from AS400 to LO Calc negative numbers are not recognized as negative because the sign of the negative value remains to the right of the number. Is there an easy way to flip the minus sign from the right side of a number to the left?
• Our production system extracts negative numbers in a strange way (at least to me). For example, displays -134 as 0000134- (for the positive is simply displayed 134 ). What formula can I write to convert it to -134 and remove the leading zeros and move the "-" sign forward?
• I'm importing a report COBOL in LO Calc and in this report negative numbers have a negative sign at the end. To use cells that contain negative numbers in the LO Calc formula, the number must be preceded by a negative sign. To be able to write formulas using these cells, I need to change the cells with negative numbers to put a minus sign in the first position. Besides changing each cell manually (which I did), is there any way to do this reformatting with a macro or something?
• We received a file LO Calc that contains negative numbers with a minus sign at the end (instead of the beginning). This is a list of cash transactions from the cash register. Is there a way to reformat only those numbers (there are tens of thousands of transactions) that have a terminal negative sign to make them negative?

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .