Hi Barb,

=TEXT(A1,"0_);(0)")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Barb Reinhardt" wrote in message
...
| How would I write the TEXT function to get a return of (123) when the number
| is < 0?
|
| Thanks