Questions? We have answers.

Converting Debit and Credit Columns to Numbers

Article author
Jonathon Plowman-Samson
  • 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.  

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.


Related articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.