Format Numbers in OpenOffice Calc

See a higher quality video on TechTutor.TV! OpenOffice Calc allows you to set the style, number of decimals, number of leading zeros, turn negative numbers to red and set a thousands separator when you go to format your numbers. Check out this video tutorial to learn how to format numbers in OpenOffice Calc. See higher quality tutorials all for FREE at www.techtutor.tv

[@beckykaye7414]

I occasionally seem to have trouble with open office makes zero balance as a red negative (doesn't always do it but more than would like to)

[@christinetan7823]

once the separator is , than change to . it's work...thanks.

[@rammanoharsah6695]

what does it means, how can we change comma (,) to decimal (.)

[@WOOOPdoctorFROGhere]

how do I remove auto-formatting from open office spreadsheets? It's driving me fking crazy! I never asked for it to add percentage signs after every number? Nor do I want it to change the date to xx/xx/xx formatting. Can somebody please tell me how to stop this fking annoying formatting its driving me up the fking wall!!!!!!!

[@jovanpopovic6303]

You just go to format cells, numbers, category, and select text.

[@WOOOPdoctorFROGhere]

@@jovanpopovic6303 yes but then the next cell will be formatted to percentage again. even when I highlight every cell and format it to general, or number, or anything else, it still fucking reverts back to percentage

[@jovanpopovic6303]

@@WOOOPdoctorFROGhere select multiple cells that you want to change.

[@WOOOPdoctorFROGhere]

@@jovanpopovic6303 I've already told you I've tried that