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?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager. 


Related articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.