Results 1 to 5 of 5

Thread: Customized Cell formatting

  1. #1

    Question Customized Cell formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi. I've read through the official help pages for cell formatting, got none. Or at least they provided not what i needed.

    I'm looking for some help to format cells in this matter, to minimize the effort of filling in the correct account number format in cells.

    I thought it would be like this according to their own description in help files, and predefined formatting sets
    PHP Code:
    ####.##.####0000.00.0000 
    But no luck in that.
    Any advice on the matter?

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,755
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Which format do you want to obtain?
    Thank you Ken for this secure forum.

  3. #3
    Quote Originally Posted by Pecoflyer View Post
    Which format do you want to obtain?
    I would prefer to get periods between the nr seqeunces: xxxx.xx.xxxxx
    All i get is spaces, not the period.
    It works with spaces for the visual effect. But to separete them with periods with formatting would be better

  4. #4
    Acolyte Bernie's Avatar
    Join Date
    Feb 2018
    Location
    Suburban NY
    Posts
    34
    Articles
    0
    Excel Version
    Excel 2016 (Win)
    To get

    xxxx.xx.xxxxx

    use the custom format

    0000\.00\.00000

    Or select the cells and run this code:

    Sub FormatMacro()
    Selection.NumberFormat = "0000\.00\.00000"
    End Sub

  5. #5
    Thank you, that did the trick

Tags for this Thread

Posting Permissions

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