| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when I enter a number, only ###### shows?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when I enter a number, only ###### shows?
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 -- Joe Mac "Greg's excel questions" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when I enter a number, only ###### shows?
Thank you!
"Joe Mac" wrote: 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 -- Joe Mac "Greg's excel questions" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter 14 the cell shows 20 | Excel Discussion (Misc queries) | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Number 6 shows as s | Excel Discussion (Misc queries) | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| when I enter 5000 the spreadsheet shows 500. Why? | Excel Discussion (Misc queries) | |||
Linear Mode
