Formats can be set on a per-column basis. Right-click on the name of a dimension or measure in the Data window on the left, and select Field Properties -> Number Format.
This presumes that you have one column that is currencies, and one column that is percentages. If you are mixing up data types in different rows (within the same column), then your data is not in a table format and Tableau will not be able to work well with it.
Question, since the formats can be applied to columns, can they be applied to rows?
When I write "columns", what I mean are "fields" - fields that are represented either as dimensions or measures in the data pane. So, the answer is no, not easily. There are "row banding" options in the formatting that are easy, but to apply data formatting based on the content of the data in each row requires writing a custom calculation to output hand-cobbled formatting or text for a color palette.