number in parentheses
I'd like to put a number in parenthesis.
i've seen that i can do the (#.#) or whever from the custom number tab in
cel format.
what i' concerned is that if i do the above an di enter 2, i get (2.) i
just want (2) but also what if i have say 2.5
i tried (#) but 2.5 gives me (3)
if i try to enter as text, i get an error asking to correct to number, then
it turns it negative.
why did M$ do this?
any help?
thanks
|