Scribd
Upload
11 views4 pages

Number Formats and Data Presentation Guide

The document provides examples of number, date, time, color, cell formatting including borders and alignment. It shows positive and negative number formats with thousands separators and decimal places. Date formats include short, long, and time. Cell formatting examples include colspan, rowspan, fonts, font sizes, and families. Border styles are shown along with color options.

Uploaded by

Ricardo David
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
11 views4 pages

Number Formats and Data Presentation Guide

The document provides examples of number, date, time, color, cell formatting including borders and alignment. It shows positive and negative number formats with thousands separators and decimal places. Date formats include short, long, and time. Cell formatting examples include colspan, rowspan, fonts, font sizes, and families. Border styles are shown along with color options.

Uploaded by

Ricardo David
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Number Formats 123456789.

12345
Format Positive Negative Format 1 Negative Format 2
1234 123456789 -123456789 123456789
1234.0 123456789.1 -123456789.1 123456789.1
1234.00 123456789.12 -123456789.12 123456789.12
1,234 123,456,789 -123,456,789 123,456,789
1,234.0 123,456,789.1 -123,456,789.1 123,456,789.1
1,234.00 123,456,789.12 -123,456,789.12 123,456,789.12
$1,234.00 $123,456,789.12 -$123,456,789.12 $123,456,789.12
Dates Times
12/31/2008 11/11/2008 10:55 1/1/09 1:44:59 AM 23:00:00
02/03/08 10:55:48 AM 1/1/09 1:45:00 AM 23:30:00
12/31 10:55:48 1/1/09 1:45:01 AM
December 31, 2008 12/1/2009
Wednesday, December 31, 2008
31-Dec
Colors
Red Green Blue Yellow

Format Colors Override Cell Colors: (444) 444

Col/Row Spans Alignment


colspan=3 left
colspan=2 center
right
colspan=2
rowspan=3 rowspan=2

Formulas
Boolean: 1 0
String: Test ABC

Borders
Thick Solid: left top right

Double: left top right

Dashed: left top right

Dotted: left top right

Border Colors: Red Green Yellow


This row is 100 px tall [Link]
The row above this is hidden Link to CNN And this
Negative Format 3 Negative Format 4
(123456789) (123456789) Col I is hidden -->
(123456789.1) (123456789.1) This is col J
(123456789.12) (123456789.12)
(123,456,789) (123,456,789)
(123,456,789.1) (123,456,789.1)
(123,456,789.12) (123,456,789.12)
($123,456,789.12) ($123,456,789.12)
Percentages Fonts
50% Bold
1.23% Italic
Underline
Bold - Italic
Bold - Underline
italic - Underline

Gray Orange Purple Cyan

Font Size Font Family


10 point Times New Roman
12 point Arial
16 point Verdana
20 point Comic Sans MS

bottom none all

bottom none all

bottom none all

bottom none all

Blue all
This also links to Google
This one too

You might also like