Outlining financial numbers

[Lane2614]

Hello,

In excel I use a lot of financial spreadsheets. Importing them in Neo office results in deviations in the outlining of numbers.
In excel the euro format comes first. Then, no mather the amount(100's 1000's etc), the numbers are outlined with the euro mark left, right under each other and the same goes for the last number. So a nice column shows up left and right outlined.
Neooffice doesn't seems to have such a format. And I can't figure out how to userdefine such a format. It all results in outlined right or left.

Please what to do, for I like to work with neooffice. And this way Excel prevalate

Lane

[jgd]

Select the column you want to format.

Go to Format > Cells… >Numbers > Currency

In the Format area, choose your language and click on the format you wish. You can enter a custom format in the Format code field.

Click OK

Hope that helps

Jacqueline

[yoxi]

I understand what you're trying to do - something like:

[Samwise]

Note that if your locale is using , as thousand separator and . as decimal separator, you should enter instead :

[Lane2614]