Leny, mungkin bisa dicoba ditambahkan karakter single apostrof ( ' ) didepan
ticket no untuk mengkonversi bilangan ke text, karena secara default setiap
angka yg diinput didalam cell akan dianggap sebagai numerik atau bisa juga
menggunakan menggunakan function [=text(TicketNo; "0000000")], mudah-mudahan
membantu...
----- Original Message -----
From: "Leny Hu" <[EMAIL PROTECTED]>
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
>
>
>
>
>
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.
