Have you tried it without the left and right parentheses? Excel might be
treating them as a math action.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel



"Kumar" wrote in message
...
Gross margin ($s)/Revenue ($s)

to show gross margin %

Unable to insert calculated field

Pls help