You are reading a single comment by @ChainBreaker 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!
=A1*1
Which column you using as A1? I am still getting a borked value #value!
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
ChainBreaker
duncs
yeah, half of them are text.
Multiply by 1 to make them numbers, then format as a date
=A1*1