Thread: Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sapperre Sapperre is offline
external usenet poster
 
Posts: 1
Default 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.