Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dollar text
Hi
I do my proposal in Excel and I'm wondering if I can format a cell to convert dollar amounts $100.00 to One Hundred Dollars and 00/100 like when I write a Check? |
#2
|
|||
|
|||
You might look at this article:
http://support.microsoft.com/default...b;en-us;213360 -- Jim "Plumb34" wrote in message ... | Hi | I do my proposal in Excel and I'm wondering if I can format a cell to | convert dollar amounts $100.00 to One Hundred Dollars and 00/100 like when I | write a Check? | | |
#3
|
|||
|
|||
Good afternoon Plumb34 This can only be handled by getting into custom function territory and writing your own function. I have a free add-in available to anyone who asks for it ) which will handle this through a custom formula which can give the result in £, $ and Euros. Please send me an e-mail if you would like to use this. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=394619 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
dollar figure to text function | Excel Worksheet Functions |