Excel
I have a report that is being exported from Crystal Reports into Excel; the
report contains two numeric columns.
When the report is run, I would like to convert the numeric columns to words
based on the contents of the cell. i.e. if the cell contains 1, change the 1
to 'Fred', if 2, change the 2 to 'John', etc.
Can anybody please suggest an answer?
Thanks.
|