Questions? We have answers.

Converting Debit and Credit Columns to Numbers in Excel

  • Updated

Summary

When transforming data into a format that best suits MindBridge, sometimes you will need to convert a column's format. In this article, we'll format a Debit/Credit or Amount column into a Number format in Excel.  

Begin by selecting the columns you wish to convert. If multiple columns need to be converted, simply press and hold CTRL, and then click each column.

image_-_2021-01-07T125405.958.png

Resolution

In the example above, columns F and G are formatted as Currency. Let's change the format to Number.

From the Number tab in the Home ribbon. click the data format drop-down and click Number.

image_-_2021-01-07T125457.349.png

Columns F and G are now in the Number format and ready to be saved as a new file!


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Was this article helpful?