Hi,

Is there a way to make a cell so when a user puts 7 to a cell and it
automatically changes to 0.7 by multiplying 0.1 to the value it has
received and show the result in the same cell?

I thought I might be able to utilize the data validation functionality
but couldn't get it to work.

Thanks in advance,
Chan