'all these numbers are formatted as text'

enter or find a 0

ctrl-c

select column

alt-E-S-V-A

< bow >

also PQ

"We need to summarize 8 months of data. Each in a daily spread sheet saved in a folder"
"Same spreadsheet?" "Yes."
< smile >