> > - > - >


(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


06:57 PM
Preview on Feedage: %D8%B4%D8%A8%D9%83%D8%A9-%D8%A7%D9%84%D8%B9%D9%85%D9%84%D8%A7%D8%A1-%D8%A7%D9%84%D9%85%D8%AD%D8%AA%D8%B1%D9%81%D9%88%D9%86 Add to My Yahoo! Add to Google! Add to AOL! Add to MSN
Subscribe in NewsGator Online Add to Netvibes Subscribe in Pakeflakes Subscribe in Bloglines Add to Alesti RSS Reader
Add to Feedage.com Groups Add to Windows Live iPing-it Add to Feedage RSS Alerts Add To Fwicki
click here Search Engine Submission - AddMe