numbers wider than cell size (column size) - displaying ###. How can I fix this?

**jjin** · 01-20-2013, 04:36 AM

Hi guys,

If have some numbers in column A (sheet 1) but the number is wider than the size of the column (for some reason, I need to keep the column size fixed). And because the numbers are wider than the column size, it displays ##### instead of its actual values.

Cells in column B are blank so I thought perhaps I can make the cell values in column A to overlap the black cells in column B using cell formatting??

But no success so far.

Any help?

attached sample excel file below

Thanks

Oh, please also note that I do not want to merge any cells.

**Fotis1991** · 01-20-2013, 04:53 AM

"Shrink to fit", isn't an option for you?

**jjin** · 01-20-2013, 05:05 AM

Unfortunately I also need to keep the size of font as well. "Shrink to Fit" adjust the size to make number fit into the cell.

**Sean Thomas** · 01-20-2013, 05:09 AM

unfortunately you cant have a number in a cell overlap another cell. It was built this way to prevent numbers being confused as being 2 cell values.
the only way is to place a text character at the start or within the string of numbers.
You will need to make the cell wider to see the number.
### will appear whenever it cant see the whole number.
ie
if the cell was 4 characters wide:
for 123 you will see 123
1234 you will see 1234
12345 you will see ####

Sorry cant help with your problem.

**oeldere** · 01-20-2013, 05:13 AM

Change the size of the format of the cells (instead of 12, make e.g. 8).

But why has it to be a fixed with?

Has it to do with printing on one page?

You can force excel to print everything on one page.

**jjin** · 01-20-2013, 05:36 AM

Hi Sean and oeldere, I have to keep the size of column B fixed because I have another table in same column but different rows.

Sean, I can't add a text character at the start of numbers in my worksheet - I have a macro running on those cells...!

Well, it is a disappointing that it cannot be fixed (guess it is actually not meant to be fixed :P) but that's fine. I will try to think of other alternatives...

Thanks guys as always

**Winon** · 01-20-2013, 09:52 AM

Hi jjin,

If you use your WorkBook in this way, and with your print Ranges set, it should print "wysiwyg".

"wysiwyg" = What you see is what you get.

numbers wider than cell size (column size) - displaying ###. How can I fix this?

LinkBack

Thread Tools

Rate This Thread

Display

numbers wider than cell size (column size) - displaying ###. How can I fix this?

Re: numbers wider than cell size (column size) - displaying ###. How can I fix this?

Re: numbers wider than cell size (column size) - displaying ###. How can I fix this?

Re: numbers wider than cell size (column size) - displaying ###. How can I fix this?

Re: numbers wider than cell size (column size) - displaying ###. How can I fix this?

Re: numbers wider than cell size (column size) - displaying ###. How can I fix this?

Re: numbers wider than cell size (column size) - displaying ###. How can I fix this?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions