Can you use?:
=RIGHT(A1,8) format as general works for me. Assumes your data is in A1.
nope tried that,
right, mid & left all take the reference from serial date even though it looks like the dd.mm.yyyy hh.mm.ss in the cell and the address bar
can turn it the other way round from number to date with =datevalue(A1) where a1 is the serial date
There are currently 1 users browsing this thread. (0 members and 1 guests)