Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Show the decimal point as( :) instead of (.)

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-21 08:39, smozgur wrote:
    or to show A3 with ( again;

    A3 => =SUBSTITUTE(SUBSTITUTE(A2,":",".")*5,".",":")
    hmmmm... this flips it back to text

    (check with =isnumber)

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Chris

    did you not check what i posted, i have no excel to test on quite yet but should work and will do the required results im sure. So oh! ok i side stepped Exel this once,,
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-21 11:49, Jack in the UK wrote:
    Chris

    did you not check what i posted, i have no excel to test on quite yet but should work and will do the required results im sure. So oh! ok i side stepped Exel this once,,
    yeah, I was just commenting on the SUBSTITUTE method

  4. #14
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,030
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-21 14:18, Chris Davison wrote:
    On 2002-04-21 11:49, Jack in the UK wrote:
    Chris

    did you not check what i posted, i have no excel to test on quite yet but should work and will do the required results im sure. So oh! ok i side stepped Exel this once,,
    yeah, I was just commenting on the SUBSTITUTE method
    I'm not very happy with the SUBSTITUTE method.

    It requires bookkeeping: Which cell is a true number and Which cell is a true time value?

    In A1 enter: 7.2
    In B1 enter: =SUBSTITUTE(A1,".",":") [ just to complicate things a bit: right-justify B1 ]
    In B2 enter: 3:02
    In C1 enter: =B1+0
    In D1 enter: =SUBSTITUTE(B1,":",".")+0
    In D2 enter: =B1+B2

    See if you come out of the above jungle.

    I'd rather avoid this kind of "playing around" in a serious workbook.

    The OP seems to be looking for a cosmetic formatting, not for a change in underlying data type. Maybe I'am wrong on this...

    Aladin

Some videos you may like

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
  •