Discussion:
Excel formula 問題
(时间太久无法回复)
Stanley
2007-05-07 08:46:00 UTC
Permalink
想問問以下情況應如何解決, 謝謝.

A1 cell - 200,000.00
B1 cell - ="A" & A1
result - A200000

請問怎樣才可顯示為A200,000.00, 謝.
Jackie Fu
2007-05-07 18:22:02 UTC
Permalink
B1 請改成 ="A"&TEXT(A1,"#,##0.00")
--
Jackie Fu


"Stanley" 來函：
Post by Stanley
想問問以下情況應如何解決, 謝謝.
A1 cell - 200,000.00
B1 cell - ="A" & A1
result - A200000
請問怎樣才可顯示為A200,000.00, 謝.
Stanley
2007-05-08 01:38:01 UTC
Permalink
thx very much^^
Post by Jackie Fu
B1 請改成 ="A"&TEXT(A1,"#,##0.00")
--
Jackie Fu
"Stanley" 來函：
Post by Stanley
想問問以下情況應如何解決, 謝謝.
A1 cell - 200,000.00
B1 cell - ="A" & A1
result - A200000
請問怎樣才可顯示為A200,000.00, 謝.
Loading...