when I enter a number, only ###### shows?

[Greg's excel questions]

When I enter a number, it appears correctly, then when I enter, it shows #####

How can I get the number to stay as is?

Also, when I print the excel spreadsheet, no rows or columns appear. I need
to keep the lines seperating each category. What do I do to keep lines??

Thank you!

 

[AnimalMagic]

On Tue, 29 Jul 2008 17:35:00 -0700, Greg's excel questions <Greg's excel

When I enter a number, it appears correctly, then when I enter, it shows #####

How can I get the number to stay as is?

Also, when I print the excel spreadsheet, no rows or columns appear. I need
to keep the lines seperating each category. What do I do to keep lines??

Thank you!

Widen the cell. The number is wider than the cell is... visually
speaking.

OR, you can shrink the font.

To keep lines use borders, OR set up excel so that grid lines are
printed in the main excel options.

The borders are much easier though.

 

[Joe Mac]

Issue #1:
Try widening the column, double click on the column separator to
automatically adjust the width to the maximum necessary to fit the value...
Issue #2:
File > Page Setup> Sheet Tab under the Print section
Select the values that you desire (you indicated Gridlines and Row & Column
headings) both are explicit selections

 

[Greg''s excel questions]

Thank you!

Issue #1:
Try widening the column, double click on the column separator to
automatically adjust the width to the maximum necessary to fit the value...
Issue #2:
File > Page Setup> Sheet Tab under the Print section
Select the values that you desire (you indicated Gridlines and Row & Column
headings) both are explicit selections