Problems with macro recording.

Hi,

I created a macro to edit a cell with a function and convert it to text by putting a space at the beginning of the cell.
When recording a macro, more than key strokes are being recorded. That is I start the recording, click at beginning of cell(selecting it), spacebar( changing contents from function to text), enter, stop recording. Create the macro, then run the macro on the next cell. The next cell I run the macro on the contents are over writen. The contents of the cell from the recording is part of the macro and over writes the data. is that the way it is suppose to work?

Please help.

I didn't find the right solution from the Internet.

References:-
https://forum.openoffice.org/en/forum/viewtopic.php?f=16&t=74791
creative infographic design quote

Thanks!