Format value in column Automatically

[itselflearn]

Please help to achieve the following scenario:

Column A : after value is entered it should turn it to UPPERCASE automatically
Column B : after a value is entered it should add .001 to it and turn it to UPPERCASE automatically
Column D : after value is entered it should turn it to PROPER automatically
Column E : after value is entered it should turn it to PROPER automatically
Column G to I : after value is entered it should turn it to UPPERCASE automatically


Thank you.

[venkat1926]

right click sheet 1 (relevant sheet)
click view code
in the window that comes up paste this event code

Please Login or Register  to view this content.

save the file. now try entering data and check . see the comments in the code. If necesary modify the code.