How to stop Calc formating cells?

Hi,

I am typing data on Calc and I have these numbers 1,220 ; 223 ; 223,3

Well, I am not able to type that at Calc.

If I type 1,220 it automatically deletes the last zero, which is not what I want.

To solve that problem I go to Format, Cells, Numbers and I choose 3 decimals.

Well, in that case it appears another problem, when I type 223 it shows 223.000

So, Is there any way to just type 1,220 or 1,100 AND 245 at the same time without deleting or adding zeros?

I mean if the format are numbers, I know I could simply choose text, but that is not what I want.

Thanks!

It seems the problem is the regional setting for the decimal “symbol” in your OS and in LibO Tools > options > languages > decimal separator key and the your local setting on the same tab.

If you want to use the " , " as a decimal symbol you need to consistently set it up in your OS and in LibO. Typically language settings are used to “automatically” set it all up.

Next you need to format your cells. Right click on a cell and look for the format you need. It is possible (99% sure) to suppress zeros after the decimal point but I don’t know the right settings by heart. Play around and you will find it.

My personal dream is that I can set up in the options of LibO the number format independently of OS settings and languages. In an international environment I made the experience that only a “space” as the thousand separator and a " . " as the decimal sign is understood.

Hi @ROSt53, it’s possible set up the styles for an specific language, so I think your dream came true.

@mariosv - I checked again tools > options > languages. I can select there setting for Local Settings by country even if my user interface is a different languages. This is good. But my dream is to set up number and date formates independent on user interfaces and languages. Should this be possible please let me know… …and you become my very best friend. For the next ~ 6 month I will remain on XP and then move to Linux.

@ROSt53, set up the cell style for an specific language: [Ctrl+1] or editing an style, select Numbers tab, Language option.

There is no way to retain zeroes without value in decimals positions, except you enter the numbers as text not as numbers, with a single quote before the number or formatting the cells as text @.

But doing so, only direct references interpreting it as numbers, e.g.:
A1: '1
B1: =A1*2 = 2
B2:=SUM(A1) = 0

Explaining a bit the context for that need, maybe someone can give a solution or a workaround.

Thanks for your replies.

I am working for a guy who needs it to be typed into Excel, I just wanted to type it as similarly as the jpeg that he sent me to work with.