Coba hilangin tanda baca (') nya. Krn utk save file mjd csv tdk boleh ada tanda baca.
Sent from my BlackBerry®
Wrong spell may appear
-----Original Message-----
From: beatrix_pintaomas@yahoo.com
Sender: XL-mania@yahoogroups.com
Date: Tue, 5 Oct 2010 16:44:36
To: <XL-mania@yahoogroups.com>
Reply-To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Error data angka format CSV
Halo para pakar xl,
Saya memiliki masalah dengan format CSV di excel 2007. Saya memiliki data2 angka sbg berikut di xlx : (format sudah sy ubah menjadi 'text' atau sy beri apostrop (')..
1) 1234567891123 (13 digit)
2) 012345678 (ada angka 0 didepan angka)
Saat saya save dengan format xlx tidak ada masalah,,
Namun, data ini harus saya upload dengan format csv (comma delimited), tampilannya menjadi spt ini :
1) 1.2E+12 (angka mjd dempet)
2) 12345678 (angka 0 hilang di depan)
Mohon bantuannya.. Agar data yg disave di file csv ttp sama dengan data aslinya karena data harus diupload dgn format csv.. Terima Kasih..
Beatrix.P
Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT
------------------------------------
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| ooooOOooOooOooOooOoooOoo ngantuukkkkk... badday pasti berlalu... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+Yahoo! Groups Links
------------------------------------
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| ooooOOooOooOooOooOoooOoo ngantuukkkkk... badday pasti berlalu... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/XL-mania/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/XL-mania/join
(Yahoo! ID required)
<*> To change settings via email:
XL-mania-digest@yahoogroups.com
XL-mania-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
XL-mania-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Nenhum comentário:
Postar um comentário