change formatting of numbers before converting with string function

[Sundaram Sridharan]

I have a need to convert numbers to string (as I need to add > or < to some of them) - when I do this in a calculated formula, it keeps only two decimals in the number. the string function help clearly states:

"Note that this function always uses the default value formatting. This might lead to lose precision when converting numerical values"

I do not know how to change the default value formatting. I went to Tools->options. I do see Axis Formatting. But changing the formatting in there don't seem to change the formatting of numbers after I apply the string conversion.

[Kirsten Smith]

Click on Data/Column Properties, highlight the column in question then click on the 'Formatting' tab to change the format of the number.

[Sundaram Sridharan]

Here is an example of what I am trying to do: on the first column you have numbers formatted as "general" - all digits showing up- I then constructed a new column = string(column1). The second column has only two decimals - I need to find out where to set the formatting that it chooses after string conversion - I cannot format the number once it is converted to type string

[Sundaram Sridharan]

finally a simple "concatenate([real],"") worked like charm