On Mon, Mar 10, 2008 at 10:40:58 -0400, Eric Cooper wrote:
> Columns of data saved in my spreadsheet are no longer displayed. At first
> I thought the data was gone, but it's in the XML file, just not being
> shown onscreen.
Right-click -> Format Cells shows the format code applied to these cells to
be "#_" which doesn't really make sense. By choosing "Number" or "Text"
under "Categories" and selecting "Apply", the data is displayed again.
> I've attached an excerpt from a spreadsheet that has a "Check#" column
> in column D. But when opened, nothing is displayed for that column.
Only D1 through D4 are affected; the remainder of the D column is still
using the "General" format and will display content.
The data is rendered as specified in the file (although that specification
is somewhat counter-intuitive), so at this point there isn't really a bug to
fix here.
Can you retrace how the formatting of these cells was set?
Kind regards,
Ray
--
Pinky, Are You Pondering What I'm Pondering?
I think so Brain, but "instant karma" always gets so lumpy.
Pinky and the Brain in "Brainwashed Part 3: Wash Harder"
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
