Posted to microsoft.public.excel.misc

JWF

Posts: n/a

Upper case only entries

Hi - happy new year to one and all from Jane in Portbury, near Bristol,
England.

I have XP with Office 2000, is there any way to ensure entries into a column
appear as upper case only. The entries are Y, N or N/A but I need this to
only be upper case only, and as always you can request this, but it is not
always so.

Thanks if you can help.
xJane

Reply With Quote

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
I NEED HELP with the SPELLNUMBER Function	vag	Excel Worksheet Functions	0	June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS	vag	Excel Worksheet Functions	1	June 15th 05 05:57 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 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

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us