Special cell formatting

[Guest]

How do you:
Have a cell equal another cell and display in written numeric like a check.

$5,250.30 displays Five-thousand two hundred fifty dollars and 30
cents.


Thanks!

 

[Fredrik Wahlgren]

How do you:
Have a cell equal another cell and display in written numeric like a check.

$5,250.30 displays Five-thousand two hundred fifty dollars and 30
cents.


Thanks!

 

[Fredrik Wahlgren]

How do you:
Have a cell equal another cell and display in written numeric like a check.

$5,250.30 displays Five-thousand two hundred fifty dollars and 30
cents.


Thanks!

It seems as if I accidentally hit the send button withot having typed
anything. Here's a link with VBA code that does what you want.
http://www.meadinkent.co.uk/xlnumberstext.htm

/Fredrik