M Mel Jul 9, 2003 #1 Is there a way to format a value (ex. $948.82) to read as nine hundred forty eight dollars and eighty two cents? THANKS!!!!
Is there a way to format a value (ex. $948.82) to read as nine hundred forty eight dollars and eighty two cents? THANKS!!!!
T Tim Otero Jul 9, 2003 #2 Hi Mel, There is no formatting to do this, but you can accomplish it with a custom function. Here is one (in accountants section): http://www.bygsoftware.com/examples/examples.htm Also, you could do a google search for something like "Spell Dollars" or "Numbers to Words" (thank you Bob Phillips). tim
Hi Mel, There is no formatting to do this, but you can accomplish it with a custom function. Here is one (in accountants section): http://www.bygsoftware.com/examples/examples.htm Also, you could do a google search for something like "Spell Dollars" or "Numbers to Words" (thank you Bob Phillips). tim
