Hi Macros...,
I am preparing an excel sheet with validation it should not allow the
special characters in a coloumn. Suppose we entered specail character in
between the word, the cell should format like red color. pls help
urgent.
Thanks
Sai.
On 28 October 2011 05:
Hai Macros,
I want to make the condittional formatting for A Coloumn in an
Excel sheet, Condition is " It should only allow Alphabets [a-zA-z]
and should not allow any special characters and numbers.Could you please
help me out in this regard,
Thanks
Sai
On 17 October 2011 05:05,
Hi Macros,
How could we fix the date format to "DD/MM/YY". So, If we enter other
format it should convert to "DD/MM/YY"
Ex: I want like DD MM YY only
24/11/1985 --- This is correct format
11/24/1985 this should convert into 24/11/1985 automatical how it is
possible...
