View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
leo leo is offline
external usenet poster
 
Posts: 74
Default 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!