|
|
Posted by Stan McCann on 06/07/06 15:16
Gobi <nospam@nobody.com> wrote in news:nRuhg.253432$WI1.8625@pd7tw2no:
> Mark Parnell wrote:
>> Deciding to do something for the good of humanity, Gobi
>> <nospam@nobody.com> declared in alt.html:
>>
>> Adrienne is on the right track. You need to somehow tell Excel to
>> treat the cell value as a string instead of an integer. If putting
>> quotes around it doesn't help though, I don't know how you'd
>> achieve that.
>>
>
> Actually, I put a space in front of the data instead of quotes. I
> was hoping for a solution where I don't have to modify the data. I
> am thinking maybe I can somehow inform excel that this column is a
> string.
> Perhaps something in the <tr>? Or some way to turn off
> auto-formatting in excel?
>
As Mark said, Adrienne is on the right track. A space in front won't
do it, use ' and if won't be seen; it's just how you designate the
difference between a string and a number in Excel.
--
Stan McCann, "Uncle Pirate" http://stanmccann.us/
Webmaster, NMSU Alamogordo http://alamo.nmsu.edu/
Implementing http://blinkynet.net/comp/uip5.html
Navigation:
[Reply to this message]
|