hi,there has to be an easy was to do this...all i need to do is figure out how!!
if a have an excel spreadsheet, with a group of figures, but these are currently expressed as a number, how can I easily add a % symbol to the end of each cell entry without retyping each number first, then adding the symbol??
please see the example...
If some of these cells are the result of some type of formatting already, would that matter in this case?
I have tried to format as a %, but this adds an extra 2 00's to each cell, but besides that problem, this formatting does exactly what i need....another option would be to find out how to delete these extra 2 00's
Thanks,
Mark.
View attachment example.xlsx
if a have an excel spreadsheet, with a group of figures, but these are currently expressed as a number, how can I easily add a % symbol to the end of each cell entry without retyping each number first, then adding the symbol??
please see the example...
If some of these cells are the result of some type of formatting already, would that matter in this case?
I have tried to format as a %, but this adds an extra 2 00's to each cell, but besides that problem, this formatting does exactly what i need....another option would be to find out how to delete these extra 2 00's
Thanks,
Mark.
View attachment example.xlsx