View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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