my worksheet has changed to some kind of coding can anybody
help me to put it back on normal veiw?

Okay, here is my guess. Click Tools/Options on Excel's menu bar, click the
View tab on the dialog box that appears and see if the check box labeled
"Formulas" in the "Windows options" section has a check mark in it. If so,
uncheck it.

Rick