CSV file displaying ###### instead of $nn,nnn

[anjanesh]

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

 

[Ian]

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

 

[anjanesh]

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

 

[Ian]

Glad it worked. Thanks for the feedback.