Hi

I used PHP's 'fgetcsv'
(http://us3.php.net/manual/en/function.fgetcsv.php) to write data to a
..csv file. The data pretty much formatted when I opened it in 'Context'
(http://www.context.cx/) but when opened in Excel 2003, one column which
contains data like *"$105,138"* is showing as *########*.
When the cell is hovered over it shows *$105,138* in the tip but shows
*105138* in the top textbox (the one next to fx label)

How do I 'tell' Excel to display *$105,138* instead of *########* ?

Thanks


--
anjanesh

Freelance Developer
------------------------------------------------------------------------
anjanesh's Profile: http://www.excelforum.com/member.php...o&userid=27132
View this thread: http://www.excelforum.com/showthread...hreadid=544034

It's too wide for the column. Increase the column width.

--
Ian
--
"anjanesh" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hi
>
> I used PHP's 'fgetcsv'
> (http://us3.php.net/manual/en/function.fgetcsv.php) to write data to a
> .csv file. The data pretty much formatted when I opened it in 'Context'
> (http://www.context.cx/) but when opened in Excel 2003, one column which
> contains data like *"$105,138"* is showing as *########*.
> When the cell is hovered over it shows *$105,138* in the tip but shows
> *105138* in the top textbox (the one next to fx label)
>
> How do I 'tell' Excel to display *$105,138* instead of *########* ?
>
> Thanks
>
>
> --
> anjanesh
>
> Freelance Developer
> ------------------------------------------------------------------------
> anjanesh's Profile:
> http://www.excelforum.com/member.php...o&userid=27132
> View this thread: http://www.excelforum.com/showthread...hreadid=544034
>

Oh...that easy !
Becuase it was in csv format, I didnt want to change the style etc,
otherwise it'll ask me to save it in xls.

Thanks


--
anjanesh

Freelance Developer
------------------------------------------------------------------------
anjanesh's Profile: http://www.excelforum.com/member.php...o&userid=27132
View this thread: http://www.excelforum.com/showthread...hreadid=544034

Glad it worked. Thanks for the feedback.

--
Ian
--
"anjanesh" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Oh...that easy !
> Becuase it was in csv format, I didnt want to change the style etc,
> otherwise it'll ask me to save it in xls.
>
> Thanks
>
>
> --
> anjanesh
>
> Freelance Developer
> ------------------------------------------------------------------------
> anjanesh's Profile:
> http://www.excelforum.com/member.php...o&userid=27132
> View this thread: http://www.excelforum.com/showthread...hreadid=544034
>