jhg1226

Posts: n/a

If the user inputs lower case y/n answer How do I convert automat.

In Excel I have a column which asks for a Y or N response. If the user
inputs y or n in lower case Can I have Excel convert it to Upper Case?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Amount or Numbers in Words	ron	New Users to Excel	6	December 24th 04 07:32 PM
Is there a formula to spell out a number in excel?	Sha-nay-nay	Excel Worksheet Functions	2	December 18th 04 09:25 PM
Convert Numeric into Text	Monty	Excel Worksheet Functions	0	December 18th 04 09:25 PM
Spellnumber	Norman Jones	Excel Worksheet Functions	6	December 13th 04 07:21 AM
Identifying the Active Fill Color	Steve Conary	Excel Discussion (Misc queries)	3	December 9th 04 04:45 AM

All times are GMT +1. The time now is 01:02 PM.

About Us

"It's about Microsoft Excel"