Convert date dd.mmm.yyyy to dd/mm/yyyy

J

James8761

Board Regular
Joined
Apr 24, 2012
Messages
156
Office Version
  1. 365
Platform
  1. Windows
Hi,
I currently have dates in Cell D1 as text as 02.Apr.2017

I need to convert them to DD/MM/YYYY. Is this possible please?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
You can use the Find and Replace function to Find the . and Replace with /, Or format the cells as a date
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question Question
Date conversion
Replies
4
Views
439
MARK858
MARK858
T
  • Question Question
VBA to run when a table with a SQL query is refreshed?
Replies
0
Views
179
Tarver
T
S
  • Solved
Excel shows wrong date format in cell
Replies
5
Views
103
dmt32
D
B
  • Question Question
Validate data input in DD/MM/YYYY hh:mm format
Replies
3
Views
464
Asbestos_Jen
Asbestos_Jen
R
  • Question Question
VBA User form - UK Date Entry converts to USA Date Format
Replies
1
Views
248
Alex Blakenburg
A

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,620
Latest member
dsubash

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top