View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nayab Nayab is offline
external usenet poster
 
Posts: 62
Default How to convert Number into words in EXCEL same or a new cell ?

On Jul 5, 8:50*am, yousry wrote:
"Rao AM" wrote:
*.. like for a cell *content of *3,456 *I want this to appear in text as '
Three thousand four hundered fifty six'. Is it possible through some *Format
cell command in same cell or by copy - paste special type into a new cell ?
Thnaks,
Rao AM- Hide quoted text -


- Show quoted text -


text(A1,0) will convert the number in A1 to text