Format Cells - MS Excel VBO

[poojagupta83]

I have an excel file with multiple columns. I need to format particular columns to not contain parenthesis, no commas, no dollar signs, and two digits after the decimal. Is there a particular formatting code that I can use?

[MichealCharron]

@poojagupta83

You can use the formatting code "0.00" to get what you are looking for (if negative sign is okay).

To find the codes that the "Format Cell" action (from BP's "MS Excel VBO" VBO) will accept, you can prototype it in Excel's "Format Cells" dialog:

And then select the "Custom" category to see the proper formatting code: