thousand separator conversion from dot to comma
Yes that works fine with any thing up to a million, over that it stays as dot
separated
--
with kind regards
Spike
"Dave Peterson" wrote:
One more way.
Put 1000 in an empty cell
edit|copy
select your range to fix
edit|paste special|check multiply
clean up that cell with 1000 in it.
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
|