View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default number in parentheses

On Thu, 10 May 2007 10:54:01 -0700, Mike
wrote:

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


Would (2.0) be acceptable?

If so, then do (#.0)

Another option, if you do not need to limit the number of decimals, would be

(General)


--ron