I am attempting to convert trailing zeros that follow the decimal point so that they remain with the number. For example
Sheet 3 in the attached file shows all of the data i'm attempting to convert.
With that said, I copied these original numbers with the decimals directly into excel. When you look at the value of the first cell it doesn't include the zeros at all saying it is 181759674 instead of 18175967400.
Each number in that column should have 11 digits in all. How do i remove the decimal to all numbers, but keep all 11 digits for each number?
I attempted to use the replace all feature with blank, but that did not work.