how to add comma to a formula
Hello everyone,
Does anyone know how to add a comma to a formaula. For example:
-----
="( )$"&D7*2
-----
if d7 = 1000
then I would like the formula to return ( )$2,000
---
** Any help will be greatly apprecitated...
--
Himansu
|