Use Format cell function (select cell or cells then right click go to format
cell then go date in number tab then select format)
On Fri, Sep 23, 2011 at 5:15 PM, ck naidu wrote:
> Hi Macros,
>
> How could we fix the date format to "DD/MM/YY". So, If we enter other
> format
Dear CK,
try it...
*for dd/mm/yy format*
*Function dd_mm_yy(s As Range)
dd_mm_yy = VBA.Format(s, "dd/mm/yy")
End Function
*
*for dd mm yy format
Function with_Space(s As Range)
with_Space = VBA.Format(s, "dd" & " " & "mm" & " " & "yy")
End Function
*
--
Thanks & regards,
Noorain Ansari
*http:/
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...
pretty sweet link below on the Google Chart API and the Google Chart Image
tool editor http://imagecharteditor.appspot.com/!
2010/10/25
>
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- Filter criteria of one row - show previous
> row...<#12be5c
