View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Himansu Himansu is offline
external usenet poster
 
Posts: 40
Default 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