You are reading a single comment by @duncs and its replies.
Click here to read the full conversation.
-
=A1*1
Which column you using as A1? I am still getting a borked value #value!
-
Any chance you could upload it here. I want to see if I can copy and paste it over.
=a1*1 didn't work for me on column D
ChainBreaker
@duncs
yeah, half of them are text.
Multiply by 1 to make them numbers, then format as a date
=A1*1
1 Attachment