Cannot change date format

S

stepan1987

Board Regular
Joined
May 6, 2011
Messages
92
Hi guys,
I have a column of dates initially inputted in text format (25/Jan/2010) and I need to change the format to date (25-Jan-2010).
I change the whole columns format using "Format cells..", however the format does not change until I click on every cell and click Enter afterwards. As there are over 200 entries is there a faster way to change them all at once?

Thanks a lot!
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
Try Data - Text To Columns
Deliminated - Next
Next
Select Date - DMY
Finish


Hope that helps.
 
Upvote 0
Try using Text-To-Columns on that column. Be sure to set the Date dropbox to DMY.
 
Upvote 0
It sounds as though the original format was text.

Personally I have not found a way to change the format as you describe when originally formatted as Text.

All I can suggest is change the format back to Text and highlight the whole column.

From Edit, choose Find and then bring teh replace section up.

Choose `/` as find, and
choose `-` as replace.
 
Upvote 0
In addition to my post above, select the column and change the format to Date.

Should work fine from there onwards.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
How to change DATE format without using =UPPER(TEXT("22-04-2010","ddmmmyy")
Replies
9
Views
246
RapchikM
R
R
  • Solved
Combing text and formatting date
Replies
4
Views
57
Fluff
Fluff
G
  • Solved
History of Dates to be traced in Excel (2010) in DD/MM/YYYY format
2
Replies
11
Views
365
MARK858
MARK858
gymwrecker
  • Solved
Date Format
Replies
6
Views
326
Fluff
Fluff
SaraWitch
  • Solved
Highlight row if cell contains text but not if date is entered (but generally formatted!)
Replies
7
Views
81
etaf
etaf

Forum statistics

Threads
1,214,659
Messages
6,120,785
Members
448,992
Latest member
prabhuk279

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