Only reason I can think of for that happening would be the use of 'text' (lowercase) as a variable name.
Using keywords as variable names is a practice that should really be avoided.
Vba has a native 'Format' function which would eliminate the need for using the Text worksheet function, which, in turn (in this case) eliminate the problem that you are encountering.