Home » Excel Data Cleaning and Reporting » Page 2

Category: Excel Data Cleaning and Reporting

The Excel Data Cleaning and Reporting category groups together posts that introduce the more advanced features that assist you in formatting, referencing and reporting on large data lists. The aim is to ensure you gain a good grounding in preparing data and then creating reports and charts using these fabulous tools.

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

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”. Read more