thousand separator conversion from dot to comma
It worked ok for me.
What was in the cell beforehand?
Spike wrote:
Does anyone know an easy way of converting numbers with thousands separated
by dots to commas. One can run a replace macro which is fine but i have some
numbers such as 123.45 which actually means 123,450.00!! and it does not work
with this properly.
I know i could write some code say using instr but is there a simpler way?
Grateful for any advices, probably not using my brain and a basic answer!!
--
with kind regards
Spike
--
Dave Peterson
|