<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - V 6.0.7 or earlier: After opening a CSV file in Cal, all cells appear to be text, but cannot Format $xx.xx Cells to US Currency"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122909">bug 122909</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - V 6.0.7 or earlier: After opening a CSV file in Cal, all cells appear to be text, but cannot Format $xx.xx Cells to US Currency"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122909#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - V 6.0.7 or earlier: After opening a CSV file in Cal, all cells appear to be text, but cannot Format $xx.xx Cells to US Currency"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122909">bug 122909</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>This is normal, and indicates that you haven't set import options such that it
would detect special numbers (like currency). You either need to select proper
options at import (first of them is the said "Detect special numbers", and it
might be also necessary to tweak columns if their formatting does not conform
to your locale's conventions), or after such import, when all the data is text,
use Data->Text to Columns. *Formatting* already existing data will never change
its data type, and only can alter visual representation (if applicable).
See also this FAQ:
<a href="https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data">https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data</a>
(there another way to convert is explained, using Find & Replace, but
personally I prefer Data->Text to Columns).
Closing NOTABUG.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>