Need help: Excel automatically change input values
Thanks a lot for such a quick response. It works to solve the problem that
changes value of 1 to 0.01.
For the deliminator problem, I tried "Convert Text to Columns wizard" on one
cell, removed any deliminators there. Seems that Excel does not split the
value automatically anymore when I paste values.
Thanks again and wish you the best!
|