Formatting decimal Number as text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to show a number (really a dollar amount) as you would write on a check
10.95 as "Ten and 95/100". I wrote a function, but it's tricky. Anyone
know a way to use just straight EXCEL formatting

BTW I use Excel 200 with Win XP.

Thanks,
Don
 
The only way I can think of is by using a VLOOKUP to a table.

=VLOOKUP(INT(A1),D1:E100,2)& "and "&(A1-INT(A1))*100&"/100"

Where columns D & E are the table column D is 1,2,3 etc and column E is One,
Two, Three etc. A1 contains the original your 10.95

This is going to take some setting up if you have large numbers to deal with
(eg One Thousand Two Hundred and Thirty Four), but will be reasonable easy
with smaller numbers. Of course, with larger numbers you could split the
number up, but that will make the formula much more complex.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Numbers as Words 3
11-Place Decimal? 2
Add a decimal to each number on a list of whole numbers 2
Formatting long decimal numbers as TEXT cell, not refreshing? 2
pivot table loosing decimals (vba) 1
Reverse color numeric formatting? 2
Cell Number Format includeing other Cell Value 8
The lowest of all? 6

Back
Top