Comma Seperation issues: Numeric values are completely displayed differently
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Comma Seperation issues: Numeric values are completely displayed differently
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,656
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Comma Seperation issues: Numeric values are completely displayed differently

    what about completely new file?

    this is your file with custom format: Custom Format
    Last edited by sandy666; Jul 3rd, 2019 at 11:20 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  2. #12
    Board Regular
    Join Date
    Sep 2015
    Posts
    550
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comma Seperation issues: Numeric values are completely displayed differently

    I did that 3 times and the last file was sent on the thread. Still Nothing happens. Am in Soup
    Last edited by NimishK; Jul 3rd, 2019 at 11:21 AM.

  3. #13
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,656
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Comma Seperation issues: Numeric values are completely displayed differently

    How about the file I sent in the post#11 ?
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  4. #14
    Board Regular
    Join Date
    Sep 2015
    Posts
    550
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comma Seperation issues: Numeric values are completely displayed differently

    Yes your file was great. but then i tried copying the column from your file to my file. Still did not work. Thanks for the efforts you have taken
    This kind of thing am experiancing for first time. Never has happend like this before

    By the way is there any customFormat which will include 0. like post #1

    Will await the VBA part of it.
    Last edited by NimishK; Jul 3rd, 2019 at 11:46 AM.

  5. #15
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,656
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Comma Seperation issues: Numeric values are completely displayed differently

    this is from Macro Recorder (and it works!):

    Code:
    Sub Macro1()
     Columns("I:I").Select
        Selection.Style = "Comma"
        Selection.NumberFormat = "_(* #,##0_ );_(* (#,##0);_(* ""-""_);_(@_)"
    End Sub
    maybe it will help
    Last edited by sandy666; Jul 3rd, 2019 at 11:50 AM. Reason: unnecessary url removed
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  6. #16
    Board Regular
    Join Date
    Sep 2015
    Posts
    550
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comma Seperation issues: Numeric values are completely displayed differently

    Also am trying to recollect that this data yesterday was on excel 2010 copied the file in Excel2013 but with following code
    Code:
    With ws
        Set r = Union(.Columns("D"), .Columns("E"))
    End With
    
    
    With r.FormatConditions
       
        .Delete
       
        .Add(Type:=xlCellValue, Operator:=xlLess, Formula1:="=1000").NumberFormat = "0.00" '
        .Add(Type:=xlCellValue, Operator:=xlLess, Formula1:="=100000").NumberFormat = "0\,000.00"
        .Add(Type:=xlCellValue, Operator:=xlLess, Formula1:="=10000000").NumberFormat = "0\,00\,000.00"
        .Add(Type:=xlCellValue, Operator:=xlLess, Formula1:="=1000000000").NumberFormat = "0\,00\,00\,000.00"
        .Add(Type:=xlCellValue, Operator:=xlLess, Formula1:="=100000000000").NumberFormat = "0\,00\,00\,00\,000.00"
        .Add(Type:=xlCellValue, Operator:=xlLess, Formula1:="=10000000000000").NumberFormat = "0\,00\,00\,00\,00\,000.00"
    End with
    Is it because of the above code

  7. #17
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,656
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Comma Seperation issues: Numeric values are completely displayed differently

    sorry mate but I really can't help
    there is many masters of vba who can help
    all what I can say is: good luck and have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  8. #18
    Board Regular
    Join Date
    Sep 2015
    Posts
    550
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comma Seperation issues: Numeric values are completely displayed differently

    sorry mate but I really can't help
    there is many masters of vba who can help
    all what I can say is: good luck and have a nice day
    Thanks anyways. Will await the technical reply

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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