I have a group of numbers here that I would like to set some formatting to. I'm going to go ahead and click and then drag, so I can select all of the numbers. If you have just one, then you simply click that one. So I'm going to go ahead and select this and then right click and then go to format cells. This first tab is your numbers tab and it’s going to let you decide how you want to format your numbers.
So you can go ahead and choose a category and I have some different numbers going on here, however, this is where you would add a percent, a currency, any sort of dates. I'm going to go ahead and click on all and keep that format. I can also go down here and it will change the format and it’s going to give me a preview of an example what it’s going to look like. I'm going to go ahead and stick with the negative and the two decimal points at the end. You also have a language you could change here if you wanted. Decimal place is you could increase if you want, and it will reflect to that in the preview. You can set leading zeros if you want. You can choose to have your negative numbers red, and you could choose to have or not have a thousands separator.
It’s going to show you down at the button the format code, and this is basically all this settings that you’ve used, just turn in the codes, so it tells open office calc exactly what you want to seem. So when you're finished formatting your numbers, go ahead and click okay, and then you’ll be taken back to your list. I'm going to go ahead and click off this and you could see I have four decimal points now. My negative numbers are turned to red. I have a thousand separators, so it did exactly what I asked it to do in formatting my numbers.
Transcription by:
Scribe4you Transcription Services