| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print number larger than cell
How do I get a cell to accept a number larger than it when I do not want to
increase size of column. The cell will accept text that prints over the cell in next column but with numbers I only get "xxx". Help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print number larger than cell
You can try using
Format | Cells | and tick the [Shrink to Fit] option on the Alignment tab. You may not like what you see. "HarryN." wrote: How do I get a cell to accept a number larger than it when I do not want to increase size of column. The cell will accept text that prints over the cell in next column but with numbers I only get "xxx". Help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print number larger than cell
"JLatham" wrote: You can try using Format | Cells | and tick the [Shrink to Fit] option on the Alignment tab. You may not like what you see. "HarryN." wrote: Many thanks to you. That's a good compromise. The numbers are a bit small so I will change column width just a bit. Best wishes. How do I get a cell to accept a number larger than it when I do not want to increase size of column. The cell will accept text that prints over the cell in next column but with numbers I only get "xxx". Help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print number larger than cell
Harry
Do you need the numbers for calculation? If not, enter an apostrophe then type the number. It is now text and will fill across the adjacent cell. Gord Dibben MS Excel MVP On Thu, 6 Jul 2006 17:01:02 -0700, HarryN. wrote: "JLatham" wrote: You can try using Format | Cells | and tick the [Shrink to Fit] option on the Alignment tab. You may not like what you see. "HarryN." wrote: Many thanks to you. That's a good compromise. The numbers are a bit small so I will change column width just a bit. Best wishes. How do I get a cell to accept a number larger than it when I do not want to increase size of column. The cell will accept text that prints over the cell in next column but with numbers I only get "xxx". Help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete a number within larger number in a cell? | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Insert row number into a cell? | Excel Worksheet Functions | |||
| One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
