Header Date Modified - Adjusting Font Style and Size Problems

**herkie94** · 04-01-2009, 04:34 PM

Help!

I found this way of adding code to the Header of my excel sheet so that it posted the Date Modified (as opposed to the current date). This all works fine, except when I tried to adjust the code to adjust the font style and size, it doesn't work properly.

This was what was recommended... and it works great!

Please Login or Register  to view this content.

This is how I adjusted the font style and size... the font works, the italics works... however the font size when I look at it is actually 409pts. HELP. What on earth is going on??

Please Login or Register  to view this content.

This adjusting code stuff is VERY new for me and right now I am just trying to find a quick fix for my client as they are trying to get their price sheets out the door... way over due.

ANY Help would be greatly appreciated!

Thanks!

**Leith Ross** · 04-01-2009, 05:27 PM

Hello herkie94,

Welcome to the Forum!

When setting the font size, you must use double digits. This should set the font to 7 points.

Please Login or Register  to view this content.

**herkie94** · 04-01-2009, 06:08 PM

Originally Posted by Leith Ross

Hello herkie94,

Welcome to the Forum!

When setting the font size, you must use double digits. This should set the font to 7 points.

Please Login or Register  to view this content.

Leith,

The only problem is when I did that before, it would still keep the font size at 409 or whatever. Is there a way to change it and re-apply it, or does it automatically change when you hit save.

I am going to try it again right now.

Thanks,
Toni

**herkie94** · 04-01-2009, 06:16 PM

Yep... still doesn't work. The font still shows up at 409pts. This is just plain weird!

**herkie94** · 04-22-2009, 10:07 PM

Leith,

Were you able to look at this again and determine what I am doing wrong... or do you know of another way to set it up?

Thanks,
Toni

**Leith Ross** · 04-23-2009, 12:46 AM

Hello Toni,

It looks to me like the variable "I" is the culprit. Have you verified its value is correct? You don't need the "&7" if "I" is controlling the font size.

Please Login or Register  to view this content.

**herkie94** · 04-23-2009, 06:24 AM

The "I" was meant for italic, and even when I take that out it still doesn't work. Still goes to 409 pt size.

Do you know of another formula that will work?

Another thing that seemed to dissappear is viewing the header and footer in a separate window/menu. All the sudden it started showing the header and footer on the actual page. I guess that isn't as important as the formula though.

Anyway... I don't know why it isn't working, but it is driving me nuts.
Attached is a file with pretty much the same coding and it shows what the font is doing. AND... the month "mm" is missing... this is just WEIRD!

Thanks,
Toni