> > - > - >


(1) FORMATING NUMBERS : GENERAL NUMBER

 
LinkBack
04-03-2007, 10:39 PM   #1
V.I.P AGENT
 
  memo2007

: Mar 2007
:
: 147
: 2,552
:

:
   MSN  memo2007    Yahoo  memo2007

:


memo2007






(1) FORMATING NUMBERS :

GENERAL NUMBER FORMAT .

- :

:-
(1) (SALES3.XLS) .
(2) (C9) (F14) .
(3) FORMAT NUMBER .
(4) CALEGORY NUMBER .
(5) FORMAT CODE #,##..,.( ). SAMPLE .
(6) OK .
:

. EDIT UNDO NUMBER .

(2) ALIGNING CELL *******S :

( ) :-
[] :

1- (A7) (F7) .
2- FORMAT (ALIGNMENT) (3) .
() HORIZONTAL ( - - - ) ( ) .
() VERTICAL ( - - ) ( ) .
() ORIENTATION .
3- HORIZONTAL CENTER OK

:

3 ѡ .


[] :

1- (A3) (F5) .
2- .
3- ALIGNMENT .
4- HORIZONTAL CENTER ACROSS SELECTION
5- OK (A F )

:

.

[] :

:-=
:
1- A14 .
2- FORMAT COLUMN WIDTH .
3- USE STANDARD WIDTH OK . .
4- FORMAT ALIGNMENT WRAP TEXT .
5- OK .


(3) CHANGING FONTS :


[] :

1- (A3 F5 ) .
2- .
3- FONT SAMPLE (++) OK .

:

.

[] :

1- .
2- .
3- .
4- .

(4) UNDERLINE AND OUTLINE CELLS :

[] :

1- (A7 F7 ) .
2- FORMAT BORDER (3) :-
- BORDER = .
- STYLE = .
- COLOR = .
3- OK .

[] :

1- (A14 F14 ) .
2- .
3- BORDER .
4- BORDER OUTLINE .
5- STYLE .
6- OK .

(5) USING AUTOMATIC FORMATING :

14 ( ) .
:

1- ( A7 F14 ) .
2- FORMAT (AUTOFORMAT) :-
= TABLE FORMAT = 14 .
= SAMPLE = .
3- CLASSIC(2) SAMPLE .
4- OK .




(6) USING STYLE :-

(STYLE) :-
1- NUMBERS .
2- BORDERS .
3- FONTS .
4- ALIGUMENT .
5- PATTERNS .
6- PROTECTION .

CREATING A STYLE :

( ) :-
1- MONSTMT.XLS () .
2- FORMAT STYLE (NORMAL) .
3- DEFINE .
4- () NORMAL .
5- STYLE INCLUDES [ NUMBER , BORDER,PATTERN,PROTECTION] CHANGE .
6- CHANGE FONT FONT .
7- CHANGE ALIGNMENT (CENTER ACCROSS SELECTION) .
8- ADD .
9- OK .



:

STYLE .
:

1- (B2:D4) .
2- .
:-
- = COMMA 4 3 4123 4.123 .
- = COMMA (O) 4 3 4123.67 4.124 .
- = CURRENGCY - - - 4 - 1000 . 000.00 1 $1,000.00 .
- = CURRENCY (O) - - 4 :
1000.67 . 0011 1,001 .
- NORMAL = 1000 1000 .
- = PERCENT % 55 55% .
3- .
4- .
:

STYLE FORMAT STYLE FRAME .

(7) :

1- (C10 D14 ) .
2- FORMAT NUMBER .
3- #, # # 0 ; [RED] - # , # # 0
4- OK .
5- .


(8) :

1- C8 .
2- NUMBER NUMBER FORMAT .
3- CODE (IP) .
4- # # # - # # - # # # [ 3 3 ] .
5- NUMBER , NUMBER FORMAT .
6- CANCEL .

:

FORMAT NUMBER :-

D/MM/YY 1/03/95
D-MMM-YY 1-MAR-95
MMM-YY MAR - 95
D/MM/YY H:MM 1/MAR/95 5:20
















































memo2007 ; 04-03-2007 10:43 PM
 
05-04-2007, 04:59 AM   #2
V.I.P AGENT
 
  ameera

: Mar 2007
: Austria
: 236
: 1,605
:

:

:


ameera









..

****
****

 

« | »


memo2007 - 5 17-03-2008 10:57 PM
memo2007 - 1 05-04-2007 05:00 AM
memo2007 - 1 05-04-2007 04:58 AM
memo2007 - 1 05-04-2007 04:56 AM
memo2007 1 05-04-2007 04:49 AM


11:19 AM