dates format

[ehsas]

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

 

[Aladin Akyurek]

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]

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]

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

 

[ehsas]

thanks paddy an aladin.It works.Regards