Tag: cell format

Articles tagged as: cell format.

Formatting cell data in Calc part V: date and time

Part V of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This post is about formatting date and time as seen in the cells. Format codes that are used in date and time is discussed extensively in this entry.

[ No Comments ] Posted by Greten on 13 Apr 2013 under Free Instructional Applications

London clock tower

Formatting cell data in Calc part IV: currency or money

Part IV of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting currency or money. The red and other color(s) formatting for negative numbers is also discussed in this post.

[ No Comments ] Posted by Greten on 13 Apr 2013 under Free Instructional Applications

coins and bills

Formatting cell data in Calc part III: percentage, fraction and scientific notation

Part III of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting cell data as fractions, percentages and scientific notations.

[ 2 Comments ] Posted by Greten on 13 Apr 2013 under Free Instructional Applications

a sliced cake representing fraction

Formatting cell data in Calc part II: numbers

Part II of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting numbers in general and the meaning of Format code made of zeroes and hashes. Also discussed are the different formats of thousands separator and decimal marker.

[ No Comments ] Posted by Greten on 13 Apr 2013 under Free Instructional Applications

an abacus, a useful representation of real numbers

Formatting cell data in Calc spreadsheet

Part I of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This is the introduction part and also covers how to select cells to be formatted and how to open the Format Cells option window.

[ No Comments ] Posted by Greten on 13 Apr 2013 under Free Instructional Applications

formatting spreadsheet cell data in Calc

Free and open source software technology and internet usage guide for teachers and other professionals in the education sector