Formatting decimal Number as text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DRA - 21 Sep 2006 19:45 GMT

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

Reply to this Message

Ian - 21 Sep 2006 21:11 GMT

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.

Signature

Ian
--

>I want to show a number (really a dollar amount) as you would write on a
>check
[quoted text clipped - 5 lines]
> Thanks,
> Don

Reply to this Message