Thread: Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Chapman[_2_] Colin Chapman[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel

I want to know how to convert a cell to a number

When I do my expenses column N36 calculates the sum of the claim

eg £1246.78
in cell D40 I have to write the total in words

Can I get a formula to do this automatically?

Any help please

Colin