Huge Date prints on spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carla F. - 11 Nov 2004 15:55 GMT

When I print a spreadsheet there is a HUGE date trying to print across the
page. I have looked in headers & footers and can't figure out what's going
on. It looks kind of like a heavy watermark or something, but I've set no
such thing.

Thanks,

Signature

Carla

Reply to this Message

David McRitchie - 11 Nov 2004 22:25 GMT

Hi Carla,
You might have used something like &31 which would
get you 31 of 72 point (1/2 inch).

Even though Excel you will find the characters in the VBE Help
F1 (VBE HELP) --> answer wizard -> Formatting Codes for Headers and Footers

If you want an ampersand to print you must double the ampersands
within the header or footer. AT&&T

Another place where you would see large numbers, and I don't think
you would see this in printing, but
View (menu), Turn off Page Breaks View by clicking on Normal View
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> When I print a spreadsheet there is a HUGE date trying to print across the
> page. I have looked in headers & footers and can't figure out what's going
> on. It looks kind of like a heavy watermark or something, but I've set no
> such thing.
>
> Thanks,

Reply to this Message

Rate this thread: