thousand separator conversion from dot to comma
You can do that with Find/Replace (Ctrl+H).
--
Kevin Backmann
"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
|