Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jess
 
Posts: n/a
Default How do I write a formula to convert numbers to written text?

I want to write a formula or figure out how to have a cell containing 1,000
and to have a corresponding cell to reflect the written text form example
"One Thousand"
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default How do I write a formula to convert numbers to written text?

Hi Jess,

Have a look at this link

http://www.meadinkent.co.uk/xlnumberstext.htm

Regards,
Bondi

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default How do I write a formula to convert numbers to written text?

Try this website:

http://www.xldynamic.com/source/xld.xlFAQ0004.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jess" wrote:

I want to write a formula or figure out how to have a cell containing 1,000
and to have a corresponding cell to reflect the written text form example
"One Thousand"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbers stored as text causes problem with VLOOKUP bpeltzer Excel Worksheet Functions 0 February 4th 06 08:07 PM
function to convert whole numbers to written text Mani K Excel Worksheet Functions 2 December 29th 05 09:24 AM
How can I convert Text into numbers? Greta Excel Worksheet Functions 8 August 22nd 05 02:03 PM
How do I convert numbers stored as text with spaces to numbers Baffuor Excel Discussion (Misc queries) 1 May 24th 05 07:39 AM
How do you convert numbers as "text" to values for a long column . geoexcel Excel Discussion (Misc queries) 2 February 27th 05 04:31 PM


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"