This website explains how to do what you're asking for:

http://www.xldynamic.com/source/xld.xlFAQ0004.html

***********
Regards,
Ron

XL2002, WinXP-Pro


"Tim" wrote:

Hi. have a spread sheet, and need to type in dollar amount, and in another
cell, have that dollar amount written in text. Example cell 1 [$1.02] cell
2 [one dollar two cents ]
Thanks