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? Chat with us or submit a request for further assistance.


Related articles

Was this article helpful?