Hi Friends
I am having issue with formatting as date. The report came from system doesn't have proper date format. I have attached the example data.
Can you please help with the formula to fix this one?
Thanks a lot
Arpan
Hi Friends
I am having issue with formatting as date. The report came from system doesn't have proper date format. I have attached the example data.
Can you please help with the formula to fix this one?
Thanks a lot
Arpan
The dates look fine. What's the problem? Be specific.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I want in the format dd/mm/yyyy only...no time stamp
1) Select a column of dates, start with column C
2) Goto DATA > TEXT TO COLUMNS > Delimited > [x] Tab (only, deselect all others) > NEXT
3) on the "step 3" window, select DATE: MDY and click FINISH
Now that whole column is fixed. Repeat with the others.
Wait, if you want the dates removed then do this:
1) put the number 1 in an empty cell
2) COPY that cell
3) Now select ALL of the date cells, A2:C283
4) Right-click and PASTE SPECIAL > MULTIPLY > OK
5) You will see all 5 digit numbers. Format those cells a DATE> dd/mm/yyyy
Hi there
I have tried the steps above but didnt work for some reason. I am not sure why is it not working?
Ignore post #4. See post $5.
Problem for system date format. You can do as per below.
> Go to Start
> Click on "Control Panel"
> Open "Regional and language options"
> In Regional options : Clcik on "Customize" > Click on "Date" tab & change as in "short date format" : dd/MMM/yyyy
and "long date format" : dddd, MMMM dd, yyyy
Clcik on "apply" & "ok"
After that :
Try with in "D2"
Formula:Please Login or Register to view this content.
copy paste as per range down & right
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thanks a lot ...it works fine..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks