Please do NOT type in all CAPS in the subject line or the message text. It
is considered to be BAD netiquette and shouting. Google is your friend.
Typing in number to text:excel results in this

http://www.google.com/search?sourcei...text%3aexce l
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
HI ALL
I am very new in EXCEL VBA , MY NEED IS WHEN I ENTER A NUMBER IN ANY
CELL LIKE 10 I WANT EVENT CODE TO TURN THAT NUMBER TO TEXT NUMBER
MEANS TEN & SO ON .

THANNKS