Formatting text in a calc...

[Niet32]

I have a formulas that conc. 3 different fields and outputs as text.

One field is text which is easy, the other is a percent and the other is a number.

The problem is the number fields report as a raw number - like the percent will read .345233571535371531. I can round it but it still lacks the % and doesn't read right.

I want the percent to read as a percent and the number to read to one decimal and have a comma when appropriate.

Any thoughts?

Thanks

[comment]

If you need it in a text field, you need to format it yourself, i.e. round it, multiply by 100 and prefix a"%" symbol. The same applies to the other number field.

Using merged fields can save you one of the two tasks.

[Niet32]

Thanks...that's what I thought but was hoping someone smarter out there had another way.

I can't merge the data because it's for charting software.

Thanks

[Niet32]

When I said smarter...I meant than myself...

[comment]

If you are exporting as text, then no - you have to calculate the exact string of the formatted number. You could use this as a starting point.

If you are exporting as XML, I *think* you could do the formatting in the XSLT stylesheet.