Currency and Numbers formatting in excel output

[Lumjing]

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 

Unit	Price/Count	20240121	20240122	20240123	20240124	20240201	20240202	20240205
Hardware	Price	$1,200	$1,400	$1,600	$1,700	$1,800	$1,900	$2,000
	Count	232	232	233	233	234	231	230
Tools	Price	$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
	Count	645	123	456	789	32	45	63

[cjaneczko]

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.