ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   AutoFill Numbers- shows up ### (https://www.excelbanter.com/excel-worksheet-functions/247159-autofill-numbers-shows-up.html)

tearose

AutoFill Numbers- shows up ###
 
I had Numbers down a column 1-200. Then I updated my Microsoft Office Suite
2007 and now every number past 99 is ### when I go to print preview. I auto
filled some more numbers and they all show up correctly, but when I print
preview it shows ###. It sounds like a setting was changed during the update
for any 3 digit number but where??

David Biddulph[_2_]

AutoFill Numbers- shows up ###
 
Have you tried a wider column or a smaller font?
--
David Biddulph

tearose wrote:
I had Numbers down a column 1-200. Then I updated my Microsoft
Office Suite 2007 and now every number past 99 is ### when I go to
print preview. I auto filled some more numbers and they all show up
correctly, but when I print preview it shows ###. It sounds like a
setting was changed during the update for any 3 digit number but
where??




Mike H

AutoFill Numbers- shows up ###
 
Hi,

Widen the column

Mike

"tearose" wrote:

I had Numbers down a column 1-200. Then I updated my Microsoft Office Suite
2007 and now every number past 99 is ### when I go to print preview. I auto
filled some more numbers and they all show up correctly, but when I print
preview it shows ###. It sounds like a setting was changed during the update
for any 3 digit number but where??



All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com