Number formats
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Number formats

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Eastbourne
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Would anyone have any ideas on how to format numbers in the form of 1st, 2nd, 3rd, 4th, etc.?
    These are conditional formats in which the two letters following the number are dependant on the units value of the number, as in common use of dates such as 22nd April.
    I would imagine that such formatting must be commonplace in the commercial workplace, but I can't think of how to get there. Any practical and simple solutions would be greatly appreciated


    _________________
    Paula in Eastbourne UK

    [ This Message was edited by: Paulasirius on 2002-04-19 04:39 ]

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Glasgow
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Paula,


    What exactly is it that you are trying to do as there is a limit of 3 conditions in conditional formatting.

    Email me a copy of the file etc .



    Jim

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See Chip Pearson's site regarding ordinal numbers in Excel.

    http://www.cpearson.com/excel/ordinal.htm

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Eastbourne
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank you, Ienze, Chip Pearson's two solutions are simply brilliant and very practical.
    I am going to try using VBA for the first time. I don't know how it is used but I'll figure it out. I used to be a wizard with Basic, Cobol and similar languages in the 80's but I've never got round to using VBA yet. It's not the code writing so much as the what to do with it once you've written the **** thing. I definitely seem to be missing out on a lot without VBA.


User Tag List

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
  •  

 

 
DMCA.com