muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to convert number to be date as format (dd/mmmm/yyyy)
from 4 digit from left as year
from 2 digit (mid first from left) as month
from 2 digit (mid second from left) as date
my target (expected result) in col. F3 down
note : no macro
any help, thank in advance.
sst
how to convert number to be date as format (dd/mmmm/yyyy)
Book1 | ||||
---|---|---|---|---|
E | F | |||
2 | data | result as date | ||
3 | 197507181996021008 | 18 Juli 1975 | ||
4 | 198012012010021006 | 20 Januari 1980 | ||
5 | 20001115 201506 2 002 | 15 Nopember 2000 | ||
6 | 19900712 200603 1 005 | 12 Juli 1990 | ||
Sheet1 |
from 4 digit from left as year
from 2 digit (mid first from left) as month
from 2 digit (mid second from left) as date
my target (expected result) in col. F3 down
note : no macro
any help, thank in advance.
sst
Last edited: