OpenOffice Calc Text to Number
 

How can you convert a number into text in Calc?

I have several numeric values that I want to format into a string-type output.

In C, I would do it as:

sprintf("%sd+%s", 4 1);

Now, I found the TEXT function. However, the documentation never seems to explain the Format portion of the TEXT function. I've tried:

TEXT(F11; "%s")

TEXT(F11; #);

TEXT(F11; "#");

TEXT(F11; '#');

Anybody get this to work?

convert cell text to number
 

a) function VALUE()

b) extension ConvertTextToNumber