dates format

ehsas

Board Regular
Joined
Sep 17, 2002
Messages
200
I need to format the below number into dates but when i am using the date format it giving me ##########.Could anyone help please.Regards,

19980207
19980318
19980419
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
On 2002-10-02 00:53, ehsas wrote:
I need to format the below number into dates but when i am using the date format it giving me ##########.Could anyone help please.Regards,

19980207
19980318
19980419

Since you have always 6-digit entries...

=DATE(LEFT(A1,4)+0,MID(A1,5,2)+0,RIGHT(A1,2)+0)
 

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
Hi there
The serial number for today on my machine is only 37531, so maybe your date is beyond the scope of Excel???
regards
Derek
PS, Ah, now if I had looked more carefully like Aladin I wouldn't feel like such a dipstick now!
This message was edited by Derek on 2002-10-02 01:07
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Temporarily adopting the persona of Mark W.:

1) select the column of interest
2) go to data | text to columns. click next twice
3) select date (YMD)as the format
4) click finish

Paddy
 

Forum statistics

Threads
1,144,059
Messages
5,722,272
Members
422,419
Latest member
Havok390

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
Top