How to set an excel column to "Accounting" type?

Help Studio
, ,
1

Howdy all, I’m currently working with an excel sheet and need to change some of the columns to accounting type. Is there an easy way to do so? I tried the below activity, and entered in “Accounting” as a custom value but that error’d out :frowning:

image

1 Like
2

ChatGPT solved it,

Entering in ($* #,##0.00);($* (#,##0.00);($* " - "??);(@_) into the custom field works.

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.