Printing output #### problem!

[Kim-Anh Tran]

Hello everyone,

I have a workbook contains several sheets. The problem on sheet 3 whic
contains many cells with values populate from sheet 1 and 2. Al
calculations and values shows accurately on the monitor but when
print it, one cell print #### instead number appears on the monitor.
can't figure out what cause the problem.

I would appreciate any help to resolve this problem!

Regards,
Kim-An

 

[Nigel]

The column width is too narrow, increase to fit.
Cheers
Nigel

 

[Kim-Anh Tran]

Thanks to Niguel!
I already try that! I don't think cell space is the problem here. Al
values appear in these cell. The cell shows value 193.8 on the monito
and I increase space but it still print #### instead 193.8 as i
appears on the monitor.
What could possibly be the problem? And how can I fix this?
Regards,
Kim-An

 

[GF6]

Cell width is the problem.
Temporarily set your zoom to 200% and resize your columns. Then go back
to your original zoom.

 

[Kim-Anh Tran]

It works! I did not allow enough space