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.
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.
Columns F and G are now in the Number format and ready to be saved as a new file!