I am trying to import categorical data into a spreadsheet. I need the
categorical data to import as numerical values (i.e. white = 1, black = 2,
hispanic = 3, etc.)
Is there a way to do this using conditional formatting? If not, please offer
a different suggestion.

Thanks!