VB for excell - question about codes

Hi Guys,

I starting to expiriment woth VB in excell, so I don't have any knowledge yet. The thing I wanted to do is create a code that would easily show a certain range of numbers in thousands or just as full numbers. I though I succeeded in making a very simple script which is the following:

Sub vermenigvuldig()
For rij = 1 To 10
For kolom = 1 To 3
If Cells(rij, kolom) <> "" Then
Cells(rij, kolom) = Cells(rij, kolom) * 10

End If
Next kolom
Next rij
End Sub
I have than the same script to divide back by 10. this worked, but my file I want to apply this script on, is a file which exist only out of lookups towards another file. I don't know why, but If I sent this file by mail. Somewhere it keeps all info, because users can still use a dropdown box per to show data in different months. Anyway to keep it short, if I aplly that script, my original data is gone en my file is not usable anymore. So I'm looking for something to be changed on my code, that it not just takes the value of the cells and muliply it, but that it enters the cell and the it inserts the multiplication behind the original formula.

Is this still clear for someone
Guys this is my first post and my first steps into vb so don't be to hard on me.
Thanks for the help !!!
shodan