<div dir="ltr">Jak ma spravne vypadat vysledek?<div>V textovem improtu lze pro kazdy sloupec nastavit format, pokud ma byt obsah bunky stejny, tak nastavit pro dany sloupec "text".</div><div>Pro ostatni zalezi jak jsou nastavene locale systemu (destinna tecka, carka, lomitko nebo tecka v datu atd...)</div>
<div><br></div><div>PK</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">Dne 27. srpna 2013 11:27 Miroslav Draxal <span dir="ltr"><<a href="mailto:evik@volny.cz" target="_blank">evik@volny.cz</a>></span> napsal(a):<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="CS" link="blue" vlink="purple"><div><p class="MsoNormal">Dobrý den,<u></u><u></u></p><p class="MsoNormal"> Tady mé vědomosti selhávají.<u></u><u></u></p>
<p class="MsoNormal">Mejme 3 sloupce (zvýrazněte, copy, vložit) do excelu.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p><span style="font-family:"Courier New""># datum / MM/DD & korekce casu (-E) / min:s & korekce (-E) / min<br>
1/1 +3:18 3.29864<br>1/2 +3:46 3.7702<br>1/3 +4:14 4.2362<br>1/4 +4:42 4.69608<br>1/5 +5:9 5.14936<br>1/6 +5:36 5.5956<br>1/7 +6:2 6.03432<br>1/8 +6:28 6.465<br>1/9 +6:53 6.88728<br>1/10 +7:18 7.30068<br>1/11 +7:42 7.70484<br>
1/12 +8:6 8.09932<br>1/13 +8:29 8.4838<br>1/14 +8:51 8.85788<br>1/15 +9:13 9.22124<br>1/16 +9:34 9.57356<br>1/17 +9:55 9.91452</span><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Proč to excel zkomolí - odskočené je chyba.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><table border="0" cellspacing="0" cellpadding="0" width="240" style="width:144.05pt;border-collapse:collapse"><tbody><tr style="min-height:14.4pt"><td width="240" nowrap colspan="3" valign="bottom" style="width:144.05pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New""># datum / MM/DD & korekce casu (-E) / min:s & korekce (-E) / min<u></u><u></u></span></p></td></tr><tr style="min-height:14.4pt">
<td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.1<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+3:18<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">3.29864<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.2<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+3:46<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">3.02<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.3<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+4:14<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">4.62<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.4<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+4:42<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">4.69608<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.5<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+5:9<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">5.14936<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.6<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+5:36<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">5.56<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.7<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+6:2<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">6.03432<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.8<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+6:28<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">6.465<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.9<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+6:53<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">6.88728<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.10<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+7:18<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">7.30068<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.11<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+7:42<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">7.70484<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.12<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+8:6<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">8.09932<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.13<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+8:29<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">8.38<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.14<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+8:51<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">8.85788<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.15<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+9:13<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">9.22124<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.16<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+9:34<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">9.57356<u></u><u></u></span></p>
</td></tr><tr style="min-height:14.4pt"><td width="61" nowrap valign="bottom" style="width:36.35pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.5pt;font-family:"Courier New"">1.17<u></u><u></u></span></p>
</td><td width="75" nowrap valign="bottom" style="width:45.1pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">+9:55<u></u><u></u></span></p>
</td><td width="104" nowrap valign="bottom" style="width:62.6pt;padding:0cm 3.5pt 0cm 3.5pt;min-height:14.4pt"><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier New"">9.91452<u></u><u></u></span></p>
</td></tr></tbody></table><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Jak na dostat importovat do excelu bez chyb? Chybné buňky se tváří jako datum. Po převodu buňky na číslo ještě vetší „průser“<u></u><u></u></p>
<p class="MsoNormal">Míra<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p></div> <br>
<br>
__________ Informace od ESET NOD32 Antivirus, verze databaze 8732 (20130827) __________<br>
<br>
Tuto zpravu proveril ESET NOD32 Antivirus.<br>
<br>
<a href="http://www.eset.cz" target="_blank">http://www.eset.cz</a><br>
</div><br>_______________________________________________<br>
HW-list mailing list - sponsored by <a href="http://www.HW.cz" target="_blank">www.HW.cz</a><br>
<a href="mailto:Hw-list@list.hw.cz">Hw-list@list.hw.cz</a><br>
<a href="http://list.hw.cz/mailman/listinfo/hw-list" target="_blank">http://list.hw.cz/mailman/listinfo/hw-list</a><br>
<br></blockquote></div><br></div>