Number stored as text
stevepctamers wrote:
Solved! Aaaaaaggghhhhh! Solvd this myself . . .
This was due to the source data being formatted as currency. The Paste
values was pasting it with the currency symbol, hence it was formatted
as text in the summary document.
So, I changed the format in the source doc to be numbers (not currency)
and Hey! Presto! it works a treat.
Good to hear.
In the future, it might be worth it to copy the cells to variants and convert
explicitly, e.g.:
Dim cell As Range, tmp As Variant
For Each cell In Selection
tmp = CCur(cell.Value)
'etc.
targetCell.Value = tmp
Next
--
The Stones, I love the Stones. I watch them whenever I can. Fred, Barney...
-- Steven Wright
|