View Single Post
  #6   Report Post  
Old July 10th 06, 08:24 AM posted to microsoft.public.excel.misc
Ardus Petus Ardus Petus is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 718
Default Default Capital letter for 1st letter of a word

You could use a Worksheet_Change event procedure to "properize" entries in
certain cells.

--
AP

"Jeff" a écrit dans le message de news:
...
Ardus,

Thanks. I will suggest to Microsoft to include this as one of excel
validation option.

Jeff.

"Ardus Petus" wrote:

AFAIK, this does not exist.
But you can copy/Paste special values from calculated column back into
original column.

Cheers,
--
AP

"Jeff" a écrit dans le message de news:
...
Hi Ardus

Thanks for you reply. Your recommended method is to use formula
=PROPER(A1).
It's referring to another cell, update to correct format and appear in
existing cell. Is there a way to update to correct format immediately
in
existing cell withot referring to another field ? Some kind of excel
validation function.

Jeff.

"Ardus Petus" wrote:

=PROPER(A1)

HTH
--
AP

"Jeff" a écrit dans le message de
news:
...
Hi, I am trying to auto format excel entry to default capital letter
for
1st
letter of each word. For example: When user insert '10,
international
building, sunny road', the entry will updated to '10, International
Building,
Sunny Road'.

Please show me the method.

Your help is very much appreciated.

Jeff.