I often use this custom format: #,###.0_);(#,###.0);-_)
and it works perfectly...
Does it for you?
--
KR
V.
"Myerse" wrote:
I want my numbers to be formatted as follows:
423
15
(2.5)
.5
10
(.5)
(2)
(23)
1,516
It is a FTE report, so most numbers are whole numbers, but some
departments have .5 for part-time employees.
When I use General formatting, the negative numbers show as -2, instead
of (2) and the decimals show as 0.5 instead of .5. I can live with
this, but was wondering how to format to get above results.
I have tried the following custom formatting, but it puts a decimal
after an integer, so 423 is 423. and (2) is (2.)
_(* #,###.##_);_(* (#,###.##);_(* "-"??_);_(@_)
Any ideas? Thanks for your help.
--
Myerse
------------------------------------------------------------------------
Myerse's Profile: http://www.excelforum.com/member.php...o&userid=35719
View this thread: http://www.excelforum.com/showthread...hreadid=555029