Format Cells - MS Excel VBO

poojagupta83 — Mon, 29 Jan 2024 17:33:56 GMT

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?

Re: Format Cells - MS Excel VBO

MichealCharron — Mon, 29 Jan 2024 18:21:51 GMT

@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:

topic Format Cells - MS Excel VBO in Product Forum

Format Cells - MS Excel VBO

Re: Format Cells - MS Excel VBO