Unfortunately, I can't mimic this behavior on my computer. However, if you want to experiment with it, here are some functions you can use.
CStr({field},"#") - convert a number to a string.
Trim({string field}) - trims the spaces from both sides of a string.
If you check out my CR Encyclopedia book, Chapter 6 lists all the built-in CR functions and gives examples of how to use them.
CR Encyclopedia