put 1 in a cell and it returns one

[Guest]

i am trying to put the number 1 in a cell and return "one" for every number I
input

 

[Debra Dalgleish]

You can use the AutoCorrect feature for this. It will also affect other
Office programs, such as Word:

Choose Tools>AutoCorrect Options
In the Replace box, type: 1
In the With box, type: one
Click OK

Type a 1 in a cell, and it will be replace with "one"
(if you type the 1 with another character, e.g. 21, it won't change)

 

[Frank Kabel]

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

 

[Paul B]

Brad, do you want to spell out the number? if so have a look here
http://www.xldynamic.com/source/xld.xlFAQ0004.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Is this a temporary thing? If so change autocorrect to replace 1 with one
Otherwise you would need an event macro that would change it

Here's a very good paper on event macros

http://www.cpearson.com/excel/events.htm

Regards,

Peo sjoblom

 

[Guest]

Thank you all...it worked great.

Brad

Brad, do you want to spell out the number? if so have a look here
http://www.xldynamic.com/source/xld.xlFAQ0004.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003