Feb 20 2020 03:34 PM
Hi,
When I cut and paste stock prices from a website into excel, the $ symbol in front of the price causes excel to automatically round the price to two digits past the decimal point. For example $53.8765 becomes $53.88. This causes problems since stock prices are frequently more than two digits past the decimal point. Is there a way to stop this from happening?$ symbol changes format of cells automatically
Feb 20 2020 04:24 PM - edited Feb 20 2020 04:35 PM
Feb 20 2020 04:26 PM