Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Format using period (Office 97)

    Hi

    Can anyone please tell how I can convert a column of numbers such as in the screenshot form 9080101 to 90.80.010 I have tried ##.##.## but it puts the periods at the end

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format using period (Office 97)

    By default, a period in a number format will be interpreted as the decimal point (if you have set Windows to use a decimal point, of course). To specify a period as a literal character, you must precede it by a backslash . Try<pre>##.##.###</pre>

    as custom format.

    Note: Excel won't treat these literal characters intelligently (as it does with the thousands separator); if your number has fewer than 5 digits, both periods will still be displayed.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Format using period (Office 97)

    Hi Hans

    Once again I'm in your debt, your reply was not only prompt but exactly what I needed.

    Many Thanks
    If you are a fool at forty, you will always be a fool

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Format using period (Office 97)

    FYI,
    Enclosing them in quotes will also work:

    ##"."##"."###

    Steve

Posting Permissions

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