I have setup a trading calculation
buy price, shipping, sell price and profit, all listed in $.
then adding profit in %, and it will show $ sign together with the results with any format settings.

That I cannot understand, I do not want a $ sign in my %.
How to remove it?

Best regards

Change the format of the Cells from "Currency" to "Number" (/Format /Cells : Numbers tab)

Please use custom defined Cell Styles instead of the direct (manual) formatting.

RoryOF wrote:Change the format of the Cells from "Currency" to "Number" (/Format /Cells : Numbers tab)

That I have tried, I have tried all, kind of numbers format, it is still show $ sign.

Best regards
Svend

Zizi64 wrote:Please use custom defined Cell Styles instead of the direct (manual) formatting.

And how am I do that?
Best regards

svelaus wrote:

Zizi64 wrote:Please use custom defined Cell Styles instead of the direct (manual) formatting.

And how am I do that?
Best regards

See Introduction to Styles

It was written for v.3.x.x. but applies equally to v4.x.x.

Always the same problem over and over and over again.
Your "numbers" are text, propably because you imported data from text file or from clipboard.
Remove all formatting from the cells and replace the currency characters with nothing.
When you import text data, always make sure that you check the "special numbers" option and that the language setting reflects the language of the data to be imported.
In this example (yahoo finance) we need English(USA) because of the special Month/Day/Year-dates, because of the point decimals and because of the am/pm times. The "special numbers" option should be always on.

Villeroy wrote:Always the same problem over and over and over again.
Your "numbers" are text, propably because you imported data from text file or from clipboard.
Remove all formatting from the cells and replace the currency characters with nothing.
When you import text data, always make sure that you check the "special numbers" option and that the language setting reflects the language of the data to be imported.
In this example (yahoo finance) we need English(USA) because of the special Month/Day/Year-dates, because of the point decimals and because of the am/pm times. The "special numbers" option should be always on.

I have not imported anything, I typed it all and was not set any formats.
It all only happen with the default settings.

I'm new to Open Office Calc, I have done the same hundreds of times in Excel.
That would do just the same, but it would have showed the $ sign in the line above the spreadsheet, and then it was only remove it or format to number.

So it is not in Calc, and that I'm very surprised about.

I have used Open Office several years ago, and I'm very sure this problems was not there on that time.

But I will try remove the dollar signs from all and try format again.

best regards

Okay I have found the solution, but I was need to remove all and start again.
first format the column I want have the percent in to number and then after format the other to currency.
That is for me the backway.

Best Regards