ExcelBanter - Text Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Text Function (https://www.excelbanter.com/excel-worksheet-functions/117236-text-function.html)

Barb Reinhardt

Text Function

How would I write the TEXT function to get a return of (123) when the number
is < 0?

Thanks

Niek Otten

Text Function

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

All times are GMT +1. The time now is 01:13 AM.