Special cell formatting

S

Sunshine

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!
 
F

Fredrik Wahlgren

Sunshine said:
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!
Click to expand...
 
F

Fredrik Wahlgren

Sunshine said:
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!
Click to expand...
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
 
Top