Hi

Simply replace "//" by "/" and do the formatting, I don't think
anything else needs to be done for this.

Regards
Rajender Soni

On Jul 20, 1:33 pm, Dave Bonallack <davebonall...@hotmail.com> wrote:
> Hi Deepak,
>
> Not quite sure what's wrong, but some of the data in Col C has a double // 
> between the year and month. Also, it's coming up on my system as Month, Day, 
> Year, which means XL doesn't recognise it as a Date. (If it did, it would 
> display it according my local settings, Day, Month, Year). A macro could be 
> written to change it to Date, if that's what you need.
>
> Regards - Dave.
>
> Date: Tue, 20 Jul 2010 11:46:49 +0530
> Subject: $$Excel-Macros$$ date format
> From: deepakexce...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi all
>
> My problem is, there is a field Date i want to change the format of all the 
> dates.
> I used alt+shift+# but all dates are not changing then i tried to value them 
> but the problem remains same.
> file is attached.
> Could u pls tell the exect problem with the data.
>
> Regards,
> Deepak
>
> --
> ---------------------------------------------------------------------------­-------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe
>
> _________________________________________________________________
> New, Used, Demo, Dealer or Private? Find it at 
> CarPoint.com.auhttp://clk.atdmt.com/NMN/go/206222968/direct/01/

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to