Results 1 to 8 of 8

Thread: Zahlen-Formatierungen kombinieren

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Oct 2022

    Zahlen-Formatierungen kombinieren


    I try to format 7 to 9-digit article numbers uniformly, e.g. 20 154 184 5 or 00 845 157 4.

    In column D I have the original data, which consists of 7 to 9-digit sequence of numbers that Excel recognises as text.

    Now I tried to convert this text into a number in column E with the formula =VALUE(D2) and then generate the uniform classification with user-defined formatting ## #### ###. This also works with 9-digit article numbers, with the 7-digit ones just 2 digits are missing.

    So next attempt with =REPEAT("0";9-LENGTH(D2))&D2 .... Now he fills up all article numbers in 9 digits, partly with 2 preceding 0. But he does not recognise the result as a number and thus the user-defined formatting does not work.

    So I need a combination of both, gladly also with VBA programming.

    Does anyone have an idea?

    Thank you very much for your help
    Last edited by Aussiebear; 10-07-2022 at 03:17 AM. Reason: Converted to English

Posting Permissions

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