thousand separator conversion from dot to comma
You can use Text to columns under Data, start by selecting your data, then go
to Data/Text to Columns, select "Fixed width" hit Next Next then hit Advance,
in the the "thousands seperator" menu select the period (.) hit OK Finish.
HTH
JG
"Spike" wrote:
Yes you would have thought so, it was the first thing i tried, this is odd
data i think ex a text file and i have run "convert to text' over it several
times and cannot make any headway. so think i will have to write a function
using instr
--
with kind regards
Spike
"Kevin B" wrote:
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
|