AUD PLATFORM
페이지 트리
메타 데이터의 끝으로 건너뛰기
메타 데이터의 시작으로 이동

이 페이지의 이전 버전을 보고 있습니다. 현재 버전 보기.

현재와 비교 페이지 이력 보기

« 이전 버전 3 현재 »

Page No.  79413689

작성자 :  고대훈 / 검수자 :  


2021년 9월 9일 기준으로 작성된 문서 입니다.
유형값출력값 (답지)NO서식 적용한 출력셀 포멧
숫자-1234(1234)1(1234)0_);[빨강](0)
(1234)2(1234)0_);(0)
1234312340;[빨강]0
-1234 4-12340_ 
-1234 5-12340_ ;[빨강]-0 
통화-1000(₩1,000)6(₩1,000)₩#,##0_);[빨강](₩#,##0)
(₩1,000)7(₩1,000)₩#,##0_);(₩#,##0)
₩1,0008₩1,000₩#,##0;[빨강]₩#,##0
-₩1,0009-₩1,000₩#,##0
(₩1,000)10(₩1,000)₩#,##0_);[빨강](₩#,##0)
회계-1000 ₩                   (1,000)11 ₩                                       (1,000)_(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
날짜2024-02-16 15:392021-09-09122024-02-16yyyy-mm-dd
2021년 9월 9일 목요일132024년 2월 16일 금요일[$-F800]dddd, mmmm dd, yyyy
2021-09-09142024-02-16yyyy-mm-dd;@
2021년 9월 9일152024년 2월 16일yyyy"년" m"월" d"일";@
21年 9月 9日1624年 2月 16日yy"年" m"月" d"日";@
2021년 9월172024년 2월yyyy"년" m"월";@
9월 9일182월 16일m"월" d"일";@
21-9-91924-2-16yy"-"m"-"d;@
21-9-9 13:532024-2-16 15:39yy"-"m"-"d h:mm;@
21-9-9 오후 1:532124-2-16 오후 3:39[$-412]yy"-"m"-"d AM/PM h:mm;@
21-9-9 1:53 PM2224-2-16 3:39 PM[$-409]yy"-"m"-"d h:mm AM/PM;@
21/9/92324/2/16yy"/"m"/"d;@
2021-9-9242024-2-16yyyy"-"m"-"d;@
2021/9/9252024/2/16yyyy"/"m"/"d;@
9/9262/16m"/"d;@
9/9/21272/16/24m"/"d"/"yy;@
09/09/212802/16/24mm"/"dd"/"yy;@
9-Sep2916-Feb[$-409]d"-"mmm;@
9-Sep-213016-Feb-24[$-409]d"-"mmm"-"yy;@
Sep-2131Feb-24[$-409]mmm"-"yy;@
September-2132February-24[$-409]mmmm"-"yy;@
S33F[$-409]mmmmm;@
S-2134F-24[$-409]mmmmm-yy;@
지수123456789011.E+10351.E+100.00E+00
123456789011.2E+10361.2E+100.00E+00
123456789011.23E+10371.23E+100.00E+00
123456789011.235E+10381.235E+100.00E+00
123456789011.2346E+10391.2346E+100.00E+00
123456789011.23457E+10401.23457E+100.00E+00
123456789011.234568E+10411.234568E+100.00E+00
123456789011.2345679E+10421.2345679E+100.00E+00
123456789011.23456789E+10431.23456789E+100.00E+00
123456789011.234567890E+10441.234567890E+100.00E+00
시간2024-02-16 15:39오후 1:53:0345오후 3:39:13[$-F400]h:mm:ss AM/PM
13:534615:39h:mm;@
13:53:034715:39:13h:mm:ss;@
오후 1:5348오후 3:39[$-412]AM/PM h:mm;@
오후 1:53:0349오후 3:39:13[$-412]AM/PM h:mm:ss;@
1:53 PM503:39 PM[$-409]h:mm AM/PM;@
1:53:03 PM513:39:13 PM[$-409]h:mm:ss AM/PM;@
2021-9-9 13:53522024-2-16 15:39yyyy"-"m"-"d h:mm;@
2021-9-9 오후 1:53532024-2-16 오후 3:39[$-412]yyyy"-"m"-"d AM/PM h:mm;@
2021-9-9 1:53 PM542024-2-16 3:39 PM[$-409]yyyy"-"m"-"d h:mm AM/PM;@
13시 53분5515시 39분h"시" mm"분";@
13시 53분 03초5615시 39분 13초h"시" mm"분" ss"초";@
오후 1시 53분57오후 3시 39분[$-412]AM/PM h"시" mm"분";@
백분율0.68514968269%5869%0%
68.5%5968.5%0.00%
68.51%6068.51%0.00%
68.515%6168.515%0.00%
68.5150%6268.5150%0.00%
68.51497%6368.51497%0.00%
68.514968%6468.514968%0.00%
68.5149682%6568.5149682%0.00%
68.51496825%6668.51496825%0.00%
68.514968247%6768.514968247%0.00%
분수123.456123 1/268123 1/2# ?/?
123 26/5769123 26/57# ??/??
123  57/12570123  57/125# ???/???
123 1/271123 1/2# ?/2
123 2/472123 2/4# ?/4
123 4/873123 4/8# ?/8
123  7/1674123  7/16# ??/16
123 5/1075123 5/10# ?/10
123 46/10076123 46/100# ??/100
텍스트텍스트 형식텍스트 형식77텍스트 형식@
우편번호12345678901234567-890781234567-890000-000
전화번호
(국번4자리)		1234567890(012) 3456-789079(012) 3456-7890[<=999999]####-####;(0##) ####-####
전화번호
(국번3자리)		1234567890(123) 456-789080(123) 456-7890[<=9999999]###-####;(0##) ###-####
주민등록번호8603081234567860308-123456781860308-1234567000000-0000000
숫자(한자)123一百二十三82一百二十三[DBNum1][$-412]G/표준
숫자(한자-갖은자)123壹百貳拾參83壹百貳拾參[DBNum2][$-412]G/표준
숫자(한글)123일백이십삼84일백이십삼[DBNum4][$-412]G/표준
기타12345123458512345G/표준
100010008610000
10001000.00871000.000
10001,000881,000#,##0
10001,000.00891,000.00#,##0.00
-0.5(1)90                                       (1)_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
123.2112391                                     123_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
0-92                                        -_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
text text 93 text _(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
-0.5(0.50)94                                   (0.50)_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
123.21123.21 95                                 123.21_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
0-   96                                      -  _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
text text 97 text _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
-0.5 ₩                        (1)98 ₩                                    (1)_(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
123.21 ₩                      123 99 ₩                                  123_(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
0 ₩                       - 100 ₩                                     -_(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
text text 101 text _(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
-0.5 ₩                     (0.50)102 ₩                                (0.50)_(₩* #,##0.00_);_(₩* (#,##0.00);_(₩* "-"??_);_(@_)
123.21 ₩                    123.21 103 ₩                              123.21_(₩* #,##0.00_);_(₩* (#,##0.00);_(₩* "-"??_);_(@_)
0 ₩                         -   104 ₩                                   -  _(₩* #,##0.00_);_(₩* (#,##0.00);_(₩* "-"??_);_(@_)
text text 105 text _(₩* #,##0.00_);_(₩* (#,##0.00);_(₩* "-"??_);_(@_)
1000010,00010610,000#,##0;-#,##0
-10000-10,000107-10,000#,##0;-#,##0
1000010,00010810,000#,##0;[빨강]-#,##0
-10000-10,000109-10,000#,##0;[빨강]-#,##0
1000010,000.0011010,000.00#,##0.00;-#,##0.00
-10000-10,000.00111-10,000.00#,##0.00;-#,##0.00
1000010,000.0011210,000.00#,##0.00;[빨강]-#,##0.00
-10000-10,000.00113-10,000.00#,##0.00;[빨강]-#,##0.00
10000₩10,000 114₩10,000₩#,##0_);(₩#,##0)
-10000(₩10,000)115(₩10,000)₩#,##0_);(₩#,##0)
10000₩10,000 116₩10,000₩#,##0_);[빨강](₩#,##0)
-10000(₩10,000)117(₩10,000)₩#,##0_);[빨강](₩#,##0)
10000₩10,000.00 118₩10,000.00₩#,##0.00_);(₩#,##0.00)
-10000(₩10,000.00)119(₩10,000.00)₩#,##0.00_);(₩#,##0.00)
10000₩10,000.00 120₩10,000.00₩#,##0.00_);[빨강](₩#,##0.00)
-10000(₩10,000.00)121(₩10,000.00)₩#,##0.00_);[빨강](₩#,##0.00)
0.971425671%1221%0%
0.971425670.97%1230.97%0.00%
0.971425679.71E-011249.71E-010.00E+00
0.97142567971.4E-3125971.4E-3##0.0E+0
123.456123 1/2126123 1/2# ?/?
123.456123 26/57127123 26/57# ??/??
-10000($10,000)128($10,000)$#,##0_);($#,##0)
10000$10,000 129$10,000$#,##0_);($#,##0)
100000($100,000)130($100,000)$#,##0_);[빨강]($#,##0)
-100000$100,000 131$100,000$#,##0_);[빨강]($#,##0)
1000000($1,000,000.00)132($1,000,000.00)$#,##0.00_);($#,##0.00)
1000000$1,000,000.00 133$1,000,000.00$#,##0.00_);($#,##0.00)
-10000000($10,000,000.00)134($10,000,000.00)$#,##0.00_);[빨강]($#,##0.00)
10000000$10,000,000.00 135$10,000,000.00$#,##0.00_);[빨강]($#,##0.00)
2024-02-16 15:392021-09-091362024-02-16yyyy-mm-dd
2024-02-16 15:392021/09/091372024/02/16yyyy/mm/dd
2024-02-16 15:392021년 09월 09일1382024년 02월 16일yyyy"년" mm"월" dd"일"
2024-02-16 15:392021年 09月 09日1392024年 02月 16日yyyy"年" mm"月" dd"日"
2024-02-16 15:3909-0914002-16mm-dd
2024-02-16 15:3909-09-2114102-16-24mm-dd-yy
2024-02-16 15:3909-Sep-2114216-Feb-24dd-mmm-yy
2024-02-16 15:3909-Sep14316-Febdd-mmm
2024-02-16 15:39Sep-21144Feb-24mmm-yy
2024-02-16 15:391:53 PM1453:39 PMh:mm AM/PM
2024-02-16 15:391:53:03 PM1463:39:13 PMh:mm:ss AM/PM
2024-02-16 15:3913:5314715:39h:mm
2024-02-16 15:3913:53:0314815:39:13h:mm:ss
2024-02-16 15:3913시 53분14915시 39분h"시" mm"분"
2024-02-16 15:392021-09-09 13:531502024-02-16 15:39yyyy-mm-dd h:mm
2024-02-16 15:3953:0315139:13mm:ss
2024-02-16 15:3953:03.515239:12.5mm:ss.0
2024-02-16 15:391066765:53:031531088127:39:13[h]:mm:ss
2024-02-16 15:39=NOW()154=NOW()@
0₩0 155₩0₩#,##0_);(₩#,##0)
-1000(₩1,000)156(₩1,000)₩#,##0_);(₩#,##0)
1000₩1,000 157₩1,000₩#,##0_);(₩#,##0)
0₩0 158₩0₩#,##0_);[빨강](₩#,##0)
-1000(₩1,000)159(₩1,000)₩#,##0_);[빨강](₩#,##0)
1000₩1,000 160₩1,000₩#,##0_);[빨강](₩#,##0)
0₩0.00 161₩0.00₩#,##0.00_);(₩#,##0.00)
-1000(₩1,000.00)162(₩1,000.00)₩#,##0.00_);(₩#,##0.00)
1000₩1,000.00 163₩1,000.00₩#,##0.00_);(₩#,##0.00)
0₩0.00 164₩0.00₩#,##0.00_);[빨강](₩#,##0.00)
-1000(₩1,000.00)165(₩1,000.00)₩#,##0.00_);[빨강](₩#,##0.00)
1000₩1,000.00 166₩1,000.00₩#,##0.00_);[빨강](₩#,##0.00)
0 ₩                          - 167 ₩                                              -_(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
-1000 ₩                   (1,000)168 ₩                                       (1,000)_(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
10000 ₩                     1,000 169 ₩                                        1,000_(₩* #,##0_);_(₩* (#,##0);_(₩* "-"_);_(@_)
0                           - 170                                                 -_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
-1000                       (1,000)171                                          (1,000)_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
10000                        1,000 172                                           1,000_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
0 ₩                        -   173 ₩                                            -  _(₩* #,##0.00_);_(₩* (#,##0.00);_(₩* "-"??_);_(@_)
-1000 ₩               (1,000.00)174 ₩                                   (1,000.00)_(₩* #,##0.00_);_(₩* (#,##0.00);_(₩* "-"??_);_(@_)
10000 ₩                  1,000.00 175 ₩                                    1,000.00_(₩* #,##0.00_);_(₩* (#,##0.00);_(₩* "-"??_);_(@_)
0                         -   176                                               -  _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
-1000                   (1,000.00)177                                      (1,000.00)_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
10000                    1,000.00 178                                       1,000.00_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
















관련 문서



  • 레이블 없음