Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

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

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Scotland
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    I have been trying without success to make a sheet I have been working on show the decimal point as ( instead of (.) The best result I have managed is (.: )by entering (0. ":" 00) in the custom box in number formatting. I would be grateful if anyone can help as my efforts does not look very professional.


    [ This Message was edited by: rmtaylor on 2002-04-21 01:07 ]

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

    Default

    erm soory to hear that, i fancy not allowuing Excel to solve this hy not windows...

    Ok riginal setting in the control pannel ahs wonderful goodies to ply with.

    try under number tab these is a decimal setting to amend to :

    then click ok.

    caution stays until re set.....

    *MARKER DECIMAL POINT*
    Free Excel based Web Toolbar available here.

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

  3. #3
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Say your source value in A1 includes (.):

    =SUBSTITUTE(A1,".",":")

    What do you think?

    [ This Message was edited by: smozgur on 2002-04-21 05:06 ]

    [ This Message was edited by: smozgur on 2002-04-21 05:06 ]

  4. #4
    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

    Smoz,

    I was going to suggest that but try multiplying the result by 5 or something, it brings back a weird result


  5. #5
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Chris,

    sure, this solution is just for viewing cell data required format, not for using the result in calculation.
    Suat

  6. #6
    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

    true !

    nice solution Smozgur


  7. #7
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just like you thought Chris..

    Suat

  8. #8
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Chris,

    If it is necessary to use that cell's original value reverse is possible:

    A1 => =25.14

    A2 => =SUBSTITUTE(A1,".",":")

    A3 => =SUBSTITUTE(A2,":",".")*5

    Yes?
    Suat

  9. #9
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    or to show A3 with ( again;

    A3 => =SUBSTITUTE(SUBSTITUTE(A2,":",".")*5,".",":")
    Suat

  10. #10
    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

    Yes,

    the *5 co-erces the text back into a number

    Chris

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
  •