Five digit Date Year

C

chipgiii

Board Regular
Joined
Nov 24, 2008
Messages
136
I have a file that in the date it gives me: 4/1/20162, 5/1/20163...

I have used every date format imaginable. Copy and Pasted values of new dates, cleared all including formats...and nothing fixes this???

Any ideas?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
how about just trim the last no at the end, e.g.

=LEFT(A1,LEN(A1)-1)
 
Upvote 0
Thanks, it was converted to a weird text format when I made the sheet into a table. Dates were in t he header row. Nothing would fix it until I removed the table, re-entered the dates and the did copy paste values...
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
How restrict copy data from form to sheet based on five days within current month
Replies
3
Views
112
Ali M
A
R
  • Solved
Cells in the same column showing different date format
Replies
5
Views
81
Peter_SSs
Peter_SSs
dezibluenose
  • Solved
Countifs formula not picking up dates, when reference columns show as dates?!
Replies
7
Views
459
Alex Blakenburg
A
R
  • Solved
How to find duplicate values in one column while checking if a condition in another column is met
Replies
8
Views
378
Ramadan2512
R
R
  • Solved
A Cell doesn't show the date formatting as set in VBA
Replies
3
Views
177
Alex Blakenburg
A

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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