[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(ÅVXV‡) | ‘S•¶ŒŸõ | ‰ß‹ŽƒƒO ]
@
w¬”‘æ‚RˆÊ–¢–žŽlŽÌŒÜ“ü‚ɂ‚¢‚Äxi‚à‚àj‚`—ñ@@@@@@@@‚a—ñ ‚RD‚O‚U‚W‚S@@@@‚RD‚O‚U‚W ‚OD‚T‚U‚X‚V@@@@‚OD‚T‚Vi‚Oj ‚P‚OD‚S‚X‚X‚U@@‚P‚OD‚Ti‚O‚Oj ‚VD‚X‚X‚X‚T@@@@‚W ã‹L‚Ì‚`—ñ‚Ì”Žš‚𬔑æ‚RˆÊ–¢–žŽlŽÌŒÜ“ü‚µ‚Ä‚a—ñ‚̂悤‚È•\‹L‚É‚·‚邽‚߂ɂ͂ǂ̂悤‚ÈŠÖ”‚ð‚a—ñ‚É“ü‚ꂽ‚ç‚æ‚낵‚¢‚Å‚µ‚傤‚©Bƒ}ƒNƒ‚ÍŽg‚¦‚Ü‚¹‚ñB ‚¨¢˜b‚É‚È‚è‚Ü‚·‚ª‚æ‚낵‚‚¨Šè‚¢‚¢‚½‚µ‚Ü‚·B Windows 7@Excel2010
ƒZƒ‹‚Ì‘Ž®‚Ì ”’l‚Ì—LŒøŒ…”‚ð3Œ…‚É‚·‚邾‚¯‚ł̓_ƒ‚È‚Ì‚Å‚µ‚傤‚©B (Mook)
‚±‚ñ‚ÈŽ®‚ð“ü‚ê‚Ä =ROUND(A1,3)&CHOOSE(LEN(A1)-LEN(ROUND(A1,3))+1," ",,"(0)","(00)",," ") ƒtƒHƒ“ƒg‚ð“™•iƒtƒHƒ“ƒg–¼‚ÉP‚ª‚‚©‚È‚¢‚à‚Ìj‚ð‘I‚ñ‚Å ”z’u‚ð‰E‹l‚É‚·‚é‚Ì‚Í‚Ç‚¤‚Å‚µ‚傤BBB
(HANA)
HANA‚³‚ñ@‚²•ÔŽ–‚ ‚肪‚Æ‚¤‚²‚´‚¢‚Ü‚µ‚½B‘Oo‚ÌŽ„‚Ì—á‘è‚Å‚ÍHANA‚³‚ñ‚Ì‘Ž®‚ÅŠ®àø‚É‚Å‚«‚Ü‚µ‚½B
ŽÀ‚ÍŽ„‚Ì—á‘肪‘«‚è‚Ü‚¹‚ñ‚Å‚µ‚½BˆÈ‘O‚Ì—á‘è‚ÆŽŸ‚Ì—á‘è‚Ì—¼•û‚ª‚Å‚«‚é‘Ž®‚ª‚ ‚è‚Ü‚µ‚½‚ç‚Ç‚¤‚©‚æ‚낵‚‚¨Šè‚¢‚¢‚½‚µ‚Ü‚·B‚¨Žè”‚ð‚¨‚©‚¯‚µ‚Ä–{“–‚É\‚µ–󂲂´‚¢‚Ü‚¹‚ñBi‚à‚àj
‚`—ñ@@@@@@@@@@@@@‚a—ñ
‚OD‚O‚O‚S‚X‚W@@@@@@‚OD‚O‚O‚T ‚V‚W,‚X‚P‚PD‚U‚X‚X‚V‚T@@‚V‚W,‚X‚P‚PD‚Vi‚O‚Oj ‚R‚U,‚O‚O‚OD@@@@@@@‚R‚U,‚O‚O‚O
B1ƒZƒ‹ =SUBSTITUTE(TEXT(ROUND(A1,3),"#,0.###")&CHOOSE(LEN(TEXT(ROUND(A1,3),"0.000"))-LEN(ROUND(A1,3))+1," ","(0)","(00)",," "),". "," ")
s ____A____ ______B______ 1 3.0684 3.068 2 0.5697 0.57(0) 3 10.4996 10.5(00) 4 7.9995 8 5 0.00498 0.005 6 78,911.70 78,911.7(00) 7 36,000.00 36,000
(”¼•½‘¾) 2012/12/02 20:18
Ž„‚ÍA”¼•½‘¾‚³‚ñ‚ÌŽ®‚Å‘‚¢‚Ä‚¨‚ç‚ê‚錋‰Ê‚ª“¾‚ç‚ê‚Ü‚µ‚½‚ªBBBH
ˆê‰žAŽ„‚àì‚Á‚½‚Ì‚ÅB =SUBSTITUTE(TEXT(ROUND(A1,3),"#,0.###")&CHOOSE(LEN(ROUNDDOWN(A1,4))-LEN(ROUND(A1,3))+1,". "," ","(0)","(00)",,". "),"..","")
(HANA)
=SUBSTITUTE(TEXT(A1,"#,0.###")&CHOOSE(6-LEN(TEXT(MOD(A1,1),"0.###"))," ","(0)","(00)"," "),". ","")
(GobGob)
‘åØ‚ÉŽg‚킹‚Ä’¸‚«‚Ü‚·B
Mook‚³‚ñAHANA‚³‚ñA”¼•½‘¾‚³‚ñA‘å•Ï‚¨¢˜b‚É‚È‚è‚Ü‚µ‚½Bi‚à‚àj
‚¿‚å‚Á‚Æ‚¾‚¯•ÏX
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(A1,"#,0.000 "),"00 ","(00)"),"0 ","(0)"),".0(00)"," ")
(GobGob)
[ ˆê——(ÅVXV‡) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.