Select all these values, Right-Click>Format Cells>Under *Number Tab* use *
Custom* and type in the box - "mm/dd/" (without quotes).
Should help you.
On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote:
> 8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009
> 5/8/2009 5/8/
I dont know why in some computers excel stores date in mm/dd/ and
in some as dd/mm/
BUT
You can convert the same to any format without using any formula or a
macro.
Just select the column containing the data (Date. in whatever format!
like 1.13.2009, or 13-1-2009, or 13/1\2009)
Go to
Hi ashish
to do this first u select the data then click right button and go to format
cells.
Then select custom in number tab.
there type "dd/mm/"
Sonia
On Mon, Sep 21, 2009 at 6:19 PM, Sonia Singla wrote:
> Hi Ashish
>
> do you want a macro for this because this you can do by changing th
Hi Ashish
do you want a macro for this because this you can do by changing the format.
Sonia
On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote:
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009
> 5/8/2009 5/8/2009 5/8/2009 5/8/2009
> THEY ARE IN DD MM
>
> I W
1-click on mouse right button then go to format cell then go to date format
then choose your option.
2- click on mouse right button then goto format cell then click on custom
then type mm dd .
On 9/21/09, ashish koul wrote:
>
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/200
Check attached file and let me if it the same ur looking for
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote:
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009
> 5/8/2009 5/8/2009 5/8/2009 5/8/200
just attcahed a file for example
On Mon, Sep 21, 2009 at 6:46 AM, Aindril De wrote:
> Right Click on the cells
> Select Format Cell
> Under Number Tab
> Choose Custom in Category
> In the Type box type MM/DD/
> Click OK
>
> Regards,
> Andy
>
> On Mon, Sep 21, 2009 at 2:05 PM, ashish koul
Right Click on the cells
Select Format Cell
Under Number Tab
Choose Custom in Category
In the Type box type MM/DD/
Click OK
Regards,
Andy
On Mon, Sep 21, 2009 at 2:05 PM, ashish koul wrote:
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009
> 5/8/2009 5/8/2009 5/8/
*Hi Ashish,*
Suppossing you have the data in column A, use following formula in column B
and drag it down.
=TEXT(A1,"mm/dd/")
or
=TEXT(A1,"mm dd ")
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
