fyi,
Dari menu format --> cell --> number --> custom
masukan angka 0 (nol) tujuh kali --> 0000000
maka angka 1 akan menjadi 0000001
Semoga bermanfaat.
----- Original Message -----
From: Leny Hu
To: [email protected]
Sent: Tuesday, May 16, 2006 11:57 AM
Subject: [BinusNet] Mau tanya ttg Excel donwload file
Hi All,
Saya punya masalah dgn output excel file (extension-nya .XLS) yang di-generate dari Oracle Form 9i. Misalkan :
Data yang saya kirim : Ticket No = 0000001, Amount = 5,000,000,
yang muncul di Excel adalah :
Ticket No Amount
1 5000000
sedangkan output yang diharapkan adalah:
Ticket No Amount
0000001 5000000
Mungkin para alumnus ada yang tahu way out -nya, please help.
I would very appreciated.
Regards,
Leny
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
[Non-text portions of this message have been removed]
BinusNet founded on Dec 28, 1998 Owner : Johan Setiawan
Moderator BinusNet : Suryadi Liawatimena & Surya Iskandar
Stop or Unsubscribe: send blank email to [EMAIL PROTECTED]
Questions or Suggestions, send e-mail to [EMAIL PROTECTED]
-=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-=
Bina Nusantara mempersembahkan
25 Tahun Bersama Binus untuk Indonesia
1981 - 2006
Venue: Plenary Hall, Jakarta Convention Center
Date : 25 February 2006
-=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-=
------------------------------------------------------------------------------
YAHOO! GROUPS LINKS
a.. Visit your group "binusnet" on the web.
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------------------------------------------------------------
[Non-text portions of this message have been removed]
BinusNet founded on Dec 28, 1998 Owner : Johan Setiawan
Moderator BinusNet : Suryadi Liawatimena & Surya Iskandar
Stop or Unsubscribe: send blank email to [EMAIL PROTECTED]
Questions or Suggestions, send e-mail to [EMAIL PROTECTED]
-=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-=
Bina Nusantara mempersembahkan
25 Tahun Bersama Binus untuk Indonesia
1981 - 2006
Venue: Plenary Hall, Jakarta Convention Center
Date : 25 February 2006
-=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-=
YAHOO! GROUPS LINKS
- Visit your group "binusnet" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
