+ Reply to Thread
Results 1 to 5 of 5

Macro to reformat numbers imported from ERP system

  1. #1
    Registered User
    Join Date
    12-03-2021
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    4

    Macro to reformat numbers imported from ERP system

    Hi All,

    Unfortunately I am not big in Excel Macros so please bare with me on this one.

    When copying information from our ERP system into Excel the values sometimes end up like this: 12456,78- (please note that this is an EU formatting, the comma (,) represents the decimal place).
    I have a macro that corrects the number to the following format: -12 457

    This was working for me for many years now, but for all of a sudden it somehow broke. If I run it now the number that I end up with is -1 245 678.
    This only happens if the minus (-) sign is at the end of the number I run the Macro on. If I have a number like 12345,99 and I run it it transforms it to 12 346 - which is correct.

    I reckon Excel must have somehow reset somthing in the formatting options.
    I would really appreciate it if you could help! I'll drop the Macro below.

    Thank you in advance!
    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 12-03-2021 at 11:51 AM. Reason: please use CODE tags

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Macro to reformat numbers imported from ERP system

    Possibly...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-03-2021
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    4

    Re: Macro to reformat numbers imported from ERP system

    WoW! Thank you for the quick response, this solved the issue!

    Thank you very much, much appreciated

    Have a nice day

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Macro to reformat numbers imported from ERP system

    Glad it worked for you!

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Macro to reformat numbers imported from ERP system

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change imported numbers in text format to numbers
    By navialivad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2014, 02:30 PM
  2. reformat numbers to dates
    By jlstidham in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2013, 10:04 PM
  3. Need to reformat mix of text and numbers
    By Sam Williams in forum Excel General
    Replies: 1
    Last Post: 01-26-2013, 10:46 AM
  4. Reformat SSN to add dashes between numbers
    By wheatgrass in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2013, 04:39 PM
  5. Need to reformat data imported from file
    By anmck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2011, 12:52 PM
  6. Macro to Reformat Numbers in a Column
    By AlmostAGeek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2008, 07:48 PM
  7. [SOLVED] How to convert Excel imported numbers from text to numbers?
    By Alden in forum Excel General
    Replies: 9
    Last Post: 04-01-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1