View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Candace Candace is offline
external usenet poster
 
Posts: 22
Default putting two functions together

I am using a function called SpellNumber

=SpellNumber(J28)

.... to automatically enter a dollar amount in words, and it works just fine.
But I want to place two asterisks (**) before and after those words. So I
tried using the CONCATENATE formula

=CONCATENATE(**,=SpellNumber(J28),**)

.... but it am getting an error message saying that this formula is not
formatted correctly. What is wrong with my formatting? Please help.