Ask Your Question

why do the numbers not appear in column

asked 2015-06-09 04:11:15 +0100

nmjaysee gravatar image

updated 2015-08-24 16:18:35 +0100

Alex Kemp gravatar image

I have numbers within the column that are ### indicating the column is too narrow. However there are larger numbers that do appear in same column. When I start enlarging the columns I have to increase all of them and they spread across the page. I've reduced font to 8.

edit retag flag offensive close merge delete


Could you give an example of a number that is hashed, a larger number that is appearing in the same column and their respective number formats.

KeithSand gravatar imageKeithSand ( 2015-06-09 16:21:17 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-06-09 06:55:18 +0100

Alex Kemp gravatar image

This is one of those RTFM questions. The section that you probably need is:-

menu:- Format Cells Numbers tab (choose 'Numbers')

What you now need to read up on is the Format code codes (press the 'Help' button). It is the '#' (hash) symbol that you are going to use, as it decides how many digits in the cell.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-09 04:11:15 +0100

Seen: 55 times

Last updated: Jun 09 '15