Maybe this

=A1/1000000000

A
B
1
20140221000000000
20140221