Home » Excel Data Cleaning and Reporting » Functions

Category: Functions

assorted numbers photography

Excel – How do I move the negative sign in front of the number?

assorted numbers photography

Anyone that regularly imports data into Excel will be familiar with the process of “data cleaning”. This is where you need to remove spaces and irrelevant data in order to get the data fit for use in Excel.

I recently had an excellent question regarding working with data imported into Excel where negative numbers are imported with the negative sign to the right of the number, e.g. 500-. These numbers are commonly referred to as “mirrored negatives”. Continue Reading