Ask Your Question
0

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

Comments

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
0

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

Stats

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

Seen: 55 times

Last updated: Jun 09 '15