Changing numbers

J

Juan Sanchez

Arnold

You can use this:

=DATE(--("19"&LEFT(D5,2)),--MID(D5,3,2),--MID(D5,5,2))

This will format as date

Cheers
Juan


-----Original Message-----
in cell a1 i have the following '7602065293082' i would
Click to expand...
like cell a2 to appear as 06/02/1976. I.e. a2 to have info
of a1 as follows: 5th & 6th digits / 3th & 4th digits / 19
& 1st & 2nd digits.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Special string convertion to date and time 5
VLookup? 2
Special converting of string date&time to date format 4
adding digits of a number 8
Pls help me to solve this problem... 13
CHANGE TEXT DATE TO NUMERIC DATE 5
Nested Formula help 0
IF calculation of Time 2

Top