Jump to content

change formatting of numbers before converting with string function


Recommended Posts

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.

Link to comment
Share on other sites

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

Capture.PNG.df6e56a881a965902bf1a60c1420291b.PNG

Link to comment
Share on other sites

×
×
  • Create New...