Hello,
A friend of mine developed a spreadsheet in Excel with all of the columns
widths at 9.0. On his laptop all of the numbers are visible. However, when
that spreadsheet is emailed and opened on a new computer, many of the larger
numbers are not visible and have the ########.
Is there a reason that the numbers would show on his computer but not on
other computers?
Is there something you can do to ensure that the numbers will be seen on all
computers / displays?
Thanks a lot,
Bob
Dave Peterson - 16 Feb 2007 15:07 GMT
Excel (and all windows programs???), use a combination of the printer driver and
the display driver to determine what to show on the screen. (In fact, you may
find that sometimes the cells look nice on the screen, but print ####'s.)
You can make the columns as wide as you think they need to be (plus a touch
more) to see if that helps.
Or maybe you could play with the font.
format|cells|alignment tab|check Shrink to fit
(in the Text Control section)
=====
Another problem can be dates. If you use mdy (like mm/dd/yy) and I use
mm/dd/yyyy then I'll need the columns to be a bit wider--or I'll see those
######'s.
> Hello,
>
[quoted text clipped - 12 lines]
>
> Bob

Signature
Dave Peterson
Don Guillett - 16 Feb 2007 15:40 GMT
It sometimes helps to use print 1 page wide and 1 page tall.
Or, for some clients I have had to actually load their printer driver on my
computer for testing in print preview mode.

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
> Hello,
>
[quoted text clipped - 12 lines]
>
> Bob
Hymer - 17 Feb 2007 02:23 GMT
Thanks Don and Dave. Much appreciated.
Bob
> It sometimes helps to use print 1 page wide and 1 page tall.
> Or, for some clients I have had to actually load their printer driver on
[quoted text clipped - 16 lines]
>>
>> Bob