Results 1 to 6 of 6

Thread: Is it possible to display just point 6 in a cell?

  1. #1

    Is it possible to display just point 6 in a cell?



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

    I would like to be able to enter the decimal portion of a minute of time from .1 to .9 and for the entry in the cell to display just the decimal point and any number from 1 to 9....Is it possible to have a cell display just the decimal point and the number?
    Thanks.

  2. #2
    Don't understand. Do you mean you want to see 00:30:00 as .5 (of an hour), or what?

  3. #3
    Bob, let me try explain again.........I have a cell in which I can enter any number from 0 to 59 to represent seconds of a minute, then that number is extracted into another cell to form part of a formula that eventually displays degrees, minutes and seconds of arc.
    Now, in another three cells, I have degrees in one, minutes in one and a cell that I wish not to put in seconds as seconds of time but as a decimal of a minute....that is....6 seconds of time = .1, 12 seconds of time = .2 and so on up to .9 representing 54 seconds of time, but not as time in the cell....so, I want to be able to enter for example, .7 in a cell without the zero in front....is this possible?

  4. #4
    Bob, I found the answer..... I custom format the cell as #.##
    Entering .7 returns a display of .7
    Great.

  5. #5
    Trouble with that is a value of 3 shows as 3, if you ever get integer values.

  6. #6
    Bob, there is no problem with integer value returns as the fractional component is entered purely as a fractional component in a cell just for the fractional component and a separate formula created in a different cell to add the fractional component to integers of my choice in which is either needed or not needed, so no problem. Thank you for your reply though.

Posting Permissions

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