simple formating Question

C

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
Hello all,

I was wondering if it is posible to convert numbers in the text, using a fomula.

for example $900.00 to " Nine Hundred Dallors" or 45.98 to Forty Five Dallors and ninetyCeight cents

so please let me knows, thanks
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
Just occurred to me that ASAP Utilities has a cool function for this also.
(Select your range of interest > ASAP Utilities from your menu (after you've downloaded it of course.) Numbers > Spell numbers or amounts.)

You can download it (for free) at:
http://www.asap-utilities.com/

Lots & lots of cool stuff in there to make life easier.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Numbers to Words without VBA
Replies
3
Views
952
Jeffrey Mahoney
Jeffrey Mahoney
DRSteele
  • Question Question
Spell out numbers into words for Cheques
Replies
3
Views
496
kweaver
kweaver
JohnZ1156
  • Solved
Formula to convert $$$ numbers to text.
Replies
5
Views
779
Joe4
Joe4
B
  • Question Question
Retain Chart Formatting when change series references
Replies
2
Views
157
Jon Peltier
J
D
  • Question Question
VBA to Remove Text Characters From Strings
Replies
5
Views
584
Fuji
F

Forum statistics

Threads
1,222,731
Messages
6,167,891
Members
452,154
Latest member
lukmana_sam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top