software

I am copying tables with numbers using quot;.quot; instead of quot;,quot; separators (Ex.
34.677.970) . When replacing quot;.quot; for quot;,quot; I got this 34,677,97 ..the Zero is
gone and Excel does not treat this as a number anymore. How can preserve
those original missing Zeros or how can those missing zeros be added so the
values are still numbers and not text.
Thanks in advance

You sshould have just relaced all the quot;,quot; with quot;quot;. This would make it a
number that Excel can recognise. Then use format it to get comma's.

quot;Ffnapaquot; wrote:

gt; I am copying tables with numbers using quot;.quot; instead of quot;,quot; separators (Ex.
gt; 34.677.970) . When replacing quot;.quot; for quot;,quot; I got this 34,677,97 ..the Zero is
gt; gone and Excel does not treat this as a number anymore. How can preserve
gt; those original missing Zeros or how can those missing zeros be added so the
gt; values are still numbers and not text.
gt; Thanks in advance