|
untuk Excel yaaaa?
sorry bikinnya pake asp mudah2an
ngerti....
<%
For x = 1 to 52
If x > 26
Then
For i = 1 to 26
huruf = chr(38 + x)
& chr(64 + i)
response.Write(huruf &
"<br>")
next
else
huruf = chr(64 +
x)
response.Write(huruf & "<br>")
end
if
next
%>
semoga membantu
Budi S
Subject: Re: [Programmer-VB] integer..TO
ALPHABET ?
Untuk A - Z coba gunakan Chr(64 + angka), misalnya untuk mengubah
angka 3 menjadi huruf C, perintahnya Chr(64 + 3).
Untuk AA - ZZ, nanti deh, mikir dulu.
Semoga bermanfaat.
Salam,
BH.
begini,
saya butuh pertolongan nih dari tman2 milis sekalian.
bagaimana ya
cara untuk merubah nilai INTEGER menjadi ALPHABET atau
tepatnya posisi
karakter menurut alpabet.
jadi lebih jelasnya
begini
1-->A
2-->B
3-->C
4-->D
..
26-->Z
WAH
TERIMA KASIH SEKALI JIKA BISA
SAMPAI
27-->AA
28-->AB
29-->AC
.
.
DST...
TERIMA
KASIH BANYAK
SEBELUMNYA..
<?REGARDS?>
Untuk
keluar dari millis ini, kirim email kosong
ke:
[EMAIL PROTECTED]
Do you Yahoo!?
Yahoo!
Mail - You care about security. So do we.
Untuk keluar dari
millis ini, kirim email kosong
ke:
[EMAIL PROTECTED]
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
--------------------
* LEGAL DISCLAIMER *
--------------------
This message is for information purposes only and its content should not be construed as an offer, or solicitation of an offer,to buy or sell any product or services and no representation or warranty is given in respect of its accuracy, completeness or fairness. The material is subject to change without notice. This message may contain confidential or legally privileged material and may not be copied, redistributed or published (in whole or in part) without our prior written consent.
This email may have been intercepted, partially destroyed, arrive late, incomplete or contain viruses and no liability is accepted by any member of the Martha Tilaar Group as a result. If you are not the intended recipient of this message, please immediately notify the sender and delete this message from your computer.
|
