<div>
The cell in Excel isn't formatted to show decimal places. &nbsp;You need to format the cell or Excel will not show insignificant digits.
</div>


The cell in Excel isn't formatted to show decimal places.  You need to format the cell or Excel will not show insignificant digits.

<div>
So, even if I format it as varchar? thanks
</div>


So, even if I format it as varchar? thanks

mcrmg

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
When I display data in SQL, I have one decimal point, for example. 1.0 or 2.0<br />
<br />
When I copy it and paste on to Excel, decimal point disappear. Here is my code to convert to text, but it is still not showing .0 in Excel.<br />

<pre><code id="code-10-29122751-1">	Select top 1 CONVERT(VARCHAR(10), CONVERT(DECIMAL(2,1),[Version]) ) + ' '
	from codex
	where [Trans Id] = W.[Trans Id]</code></pre>
</div>
</div>


Hi,

When I display data in SQL, I have one decimal point, for example. 1.0 or 2.0

When I copy it and paste on to Excel, decimal point disappear. Here is my code to convert to text, but it is still not showing .0 in Excel.
(CODE)

Convert to text to display in excel

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.