A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to get word amounts from numbers in cels



 
 
Thread Tools Display Modes
  #1  
Old September 5th, 2005, 09:58 PM
DONPITO
external usenet poster
 
Posts: n/a
Default how to get word amounts from numbers in cels

I AM USING OFFICE 2003 EXEL, AND IN MY COLUMS WHEN I MAKE A
SUM , THE RESULT OVIOUSLY COMES IN NUMBERS, MY QUESTION IS HOW
CAN I OREDR EXEL TO WRITE, A NUMBER IN WORDS IN THE CEL BELOW TO IT
  #2  
Old September 5th, 2005, 10:09 PM
Trevor Shuttleworth
external usenet poster
 
Posts: n/a
Default

Try searching Google with Excel numbers in words as the search criteria ...
lots of advice and code.

Some examples:

http://www.meadinkent.co.uk/xlnumberstext.htm
http://support.microsoft.com/default...;EN-US;Q213360

Please try not to use all capital letters ... it doesn't make it any easier
to read.

Regards

Trevor


"DONPITO" wrote in message
...
I AM USING OFFICE 2003 EXEL, AND IN MY COLUMS WHEN I MAKE A
SUM , THE RESULT OVIOUSLY COMES IN NUMBERS, MY QUESTION IS HOW
CAN I OREDR EXEL TO WRITE, A NUMBER IN WORDS IN THE CEL BELOW TO IT



  #3  
Old September 5th, 2005, 11:05 PM
Paul Sheppard
external usenet poster
 
Posts: n/a
Default


DONPITO Wrote:
I AM USING OFFICE 2003 EXEL, AND IN MY COLUMS WHEN I MAKE A
SUM , THE RESULT OVIOUSLY COMES IN NUMBERS, MY QUESTION IS HOW
CAN I OREDR EXEL TO WRITE, A NUMBER IN WORDS IN THE CEL BELOW TO IT


Hi Donpito

Try this ---- http://www.meadinkent.co.uk/xlnumberstext.htm


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401999

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Envelope Address GR New Users 5 April 24th, 2005 09:48 PM
Boiletplates from Word Perfect linda General Discussion 1 January 28th, 2005 05:37 PM
Converted document from WordPerfect. New footnotes are not being. C Lowman General Discussion 1 January 26th, 2005 10:19 PM
WP Delay Code - Word Equiv Mike G - Milw, WI General Discussion 6 January 10th, 2005 04:12 PM
Macro that will add the file path & date to Word footnotes? Rich P General Discussion 2 December 15th, 2004 07:49 PM


All times are GMT +1. The time now is 02:47 PM.


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