# Inconsistency in batch update **URL:** \ **Category:** Uncategorized\ **Created:** [January 23, 2021, 7:30pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735 "2021-01-23T19:30:35Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [January 23, 2021, 7:30pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/1 "2021-01-23T19:30:35Z")
It seems that if you manage data through batch update the numbers are exported in the format of your settings, ie in my case #,00, but when you import numbers are treats as #.00 ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 23, 2021, 7:47pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/2 "2021-01-23T19:47:38Z")
What is the number formatting of the spreadsheet? And are you saying the resulting format in an updated transaction is different from your number preference? Can you illustrate this? ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [January 23, 2021, 8:20pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/3 "2021-01-23T20:20:14Z")
The whole sheet is set to text in order not to let Excel change any format. Business number format is set to 1234,56 Batch update export the number as 1234,56 If you import exactly what was exported the number becomes 123456,00 If you change it to 1234.56 it is imported as 1.234,56 ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 23, 2021, 9:00pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/4 "2021-01-23T21:00:32Z")
That sounds somewhat similar to the bug that reported and fixed: [Asset book value errors when number format is 123.456.789,00](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529) The comma is being dropped as a decimal separator. ---
**Author:** ![dalacor](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dalacor](https://forum.manager.io/u/dalacor)\ **Post date:** [January 24, 2021, 9:43am UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/5 "2021-01-24T09:43:41Z")
This didn’t happen to me. I updated Manager yesterday and did not realise that my number format had changed to have a comma instead of decimal. I only noticed it when I tried to do a batch update and saw that Excel was trying to replace all my .00 with ,00 figures. Were you on the latest version of Manager? ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [January 24, 2021, 12:36pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/6 "2021-01-24T12:36:33Z")
Yes it is. It is a server edition which updates daily after the backup. It happened with inventory kit. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [January 25, 2021, 8:38pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/7 "2021-01-25T20:38:54Z")
Also under receipts and payments, batch update has the same issue. Export numbers with commas but wants numbers with dots for import. I understand that Manger wants only dates in format YYYY/MM/DD and numbers with dots for decimal (#.00), but, at least make the export coerent with import. And please @lubos, don’t change it again without notice. I had to change all my addon files. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [July 5, 2026, 8:24pm UTC](https://forum.manager.io/t/inconsistency-in-batch-update/32735/8 "2026-07-05T20:24:27Z")
Closed on July 5, 2026, 8:24pm UTC Uncategorized topics older than 3 years with no recent activity