Scribd
Upload
7 views4 pages

Comprehensive Guide to Number Formats

The document describes various number, date, time, and currency formats; formatting options like colors, borders, fonts, alignment, and spans; and basic formulas. It includes examples of positive and negative number formats with and without parentheses, date formats like MM/DD/YYYY and DD-Month, time formats in 12 and 24-hour notation, currency with and without symbols, percentage formats, cell colors, border styles, font styles, sizes and families, alignment, column and row spans, and Boolean and string formulas.

Uploaded by

gustavogtc
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
7 views4 pages

Comprehensive Guide to Number Formats

The document describes various number, date, time, and currency formats; formatting options like colors, borders, fonts, alignment, and spans; and basic formulas. It includes examples of positive and negative number formats with and without parentheses, date formats like MM/DD/YYYY and DD-Month, time formats in 12 and 24-hour notation, currency with and without symbols, percentage formats, cell colors, border styles, font styles, sizes and families, alignment, column and row spans, and Boolean and string formulas.

Uploaded by

gustavogtc
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

Format
1234
1234.0
1234.00
1,234
1,234.0
1,234.00
$1,234.00
Dates
12/31/2008
02/03/08
12/31
December 31, 2008
Wednesday, December 31, 2008
31-Dec
Colors
Red

123456789.1
Positive
Negative Format 1 Negative Format 2
123456789
-123456789
123456789
123456789.1
-123456789.1
123456789.1
123456789.12
-123456789.12
123456789.12
123,456,789
-123,456,789
123,456,789
123,456,789.1
-123,456,789.1
123,456,789.1
123,456,789.12
-123,456,789.12
123,456,789.12
$123,456,789.12
-$123,456,789.12 $123,456,789.12
Times
11/11/2008 10:55 1/1/09 1:44:59 AM
23:00:00
10:55:48 AM 1/1/09 1:45:00 AM
23:30:00
10:55:48 1/1/09 1:45:01 AM
12/1/2009

Green

Blue

Yellow

Format Colors Override Cell Colors:

(444)

Col/Row Spans

444
Alignment

colspan=3

left
colspan=2

center
right

colspan=2
rowspan=2

rowspan=3
Formulas
Boolean:
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

TRUE

FALSE

[Link]

The row above this is hidden

Link to CNN

And this

Negative Format 3
(123456789)
(123456789.1)
(123456789.12)
(123,456,789)
(123,456,789.1)
(123,456,789.12)
($123,456,789.12)
Percentages
50%
1.23%

Negative Format 4
(123456789)
(123456789.1)
(123456789.12)
(123,456,789)
(123,456,789.1)
(123,456,789.12)
($123,456,789.12)
Fonts
Bold
Italic
Underline
Bold - Italic
Bold - Underline
italic - Underline

Gray

Orange

Font Size

Font Family

10 point

16 point

Times New Roman


Arial
Verdana

20 point

Comic Sans MS

bottom

none

all

bottom

none

all

bottom

none

all

bottom

none

all

12 point

Blue

This also links to Google

Col I is hidden -->


This is col J

Purple

all

Cyan

This one too

You might also like