ansaurus

Question

Answer 1

A:

This usually happens when the column is not wide enough to display the data. Try and make the column wider and see if that corrects the issue.

Dave Ferguson 2010-08-03 00:11:31

Hi Dave, I'll also try your request tomorrow morning. Thanks for your response!

2010-08-03 04:50:45

Hi Dave, this didn't work for me. Thank for your suggestion.

2010-08-03 16:30:48

Answer 2

+4 A:

You can insert an apostrophe ' preceding the account number. This will force excel to treat numeric (any) data as text.

buckbova 2010-08-03 00:11:36

Hi buckbova, thank for your response. I'll try your suggestion first thing tomorrow morning.

2010-08-03 04:50:04

It works, thanks for your suggestion Buckbova!

2010-08-03 16:29:58

Answer 3

A:

If you are exporting html, you could also use the xml mso schema properties to format the number as text, without changing the actual cell value ie adding an apostrophe.

<cfheader name="Content-Disposition" value="inline; filename=someFile.xls"> 
<cfcontent type="application/vnd.ms-excel">
<html xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns="http://www.w3.org/TR/REC-html40"&gt;
<body>
<table>
 <tr>
  <td style='mso-number-format:"\@";'>510074123456989</td>
 </tr>
</table>
</body>
</html>

Leigh 2010-08-03 18:34:32

ansaurus

tags:

views:

answers:

ColdFusion export to Excel

related questions