I have a table in HTML having cells storing numbers like 123.0
,123.00
. When I use ctrl-A
to copy the whole page into excel, 123.0
and 123.00
are all changed to 123
, which is not something I want to have.
How can I disable/stop all the pre-formatting operation in excel when I am pasting an HTML table to it?