Currency and Numbers formatting in excel output

Question

Hi I have a data set as below I am doing an excel output I want the count to be in numbers and price to be in $. The problem is that the number of rows keeps changing and I cannot format in excel template.The Price and count is dynamic 1 unit can have multiple rows of price. can  you please help me in achieving this

UnitPrice/Count20240121202401222024012320240124202402012024020220240205HardwarePrice$1,200$1,400$1,600$1,700$1,800$1,900$2,000 Count232232233233234231230ToolsPrice$30,000$4,000$6,548$45,689$987,456$23,658$65,897 Price$600$56,478$32,145$12,456$65,897$987,456$25,468 Price$700$98,748$67,849$36,547$25,879$5,897$6,897 Count645123456789324563

cjaneczko · Answer

Your best bet is to apply a conditional format in Excel where the Price/Count = Price then apply $ formatting. If Price/Count = Count then apply no formatting. Since the rows are dynamic this seems like the only way to do it if you want to be able to perform any math functions in excel later. Then in the Output tool you would check the box that says to Preserve Formatting so the conditional format remains when the new data is saved into the excel file.