How would I write the TEXT function to get a return of (123) when the number is < 0? Thanks
B Barb Reinhardt Nov 2, 2006 #1 How would I write the TEXT function to get a return of (123) when the number is < 0? Thanks
N Niek Otten Nov 2, 2006 #2 Hi Barb, =TEXT(A1,"0_);(0)") -- Kind regards, Niek Otten Microsoft MVP - Excel | How would I write the TEXT function to get a return of (123) when the number | is < 0? | | Thanks
Hi Barb, =TEXT(A1,"0_);(0)") -- Kind regards, Niek Otten Microsoft MVP - Excel | How would I write the TEXT function to get a return of (123) when the number | is < 0? | | Thanks
