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?