How to determine cell format in different locals
If I use the following syntax on any locale can I expect to get
"S#" back for cell formated as scientific ?
Works in US english just wondering if it would internationally ?
can I use myFormat=cell("format",ThisCell).
If not is there a function that can change the value coming back to compare to
a speicfied LCID ?
Something like IF(
works also in other langiuage version (or your formula does at least
for the German version).
> I...Double Sided Printing
I am developing a brochure that is two fold, double sided
and multiple pages (like a magazine). When I look at
this on the screen, it is difficult to determine what the
brochure will look like printed out. Does publisher have
a way to see this as it will be printed?
If you are using Microsoft Publisher 2002 or newer, there is a print
preview. If you have a printer driver that supports print preview, such as
the highly successful HP brand printers, you might want to try that.
Microsoft Publisher MVP
Publisher FAQ Site:
"Laurie" <...where do i go to print recipes from microsoft office
I have been wanting to make a cookbook and i can't find the templates for
it...I know I saw it but can't remember where.
There are Word templates, may give you ideas
A Google search brought up quite a few templates.
Mary Sauer MSFT MVP
"cooking momma" <cooking email@example.com> wrote in message
>I have been wanting to make a ...Conditional formating for the month
I have a column with the birthday of some clients and I want the cell format
to change to yellow when his date of birth is withing the current and the
next monat. In order to do that I wrote these formula in the first and
second field of the conditional formating panel=C2=MONTH(TODAY()) and
=C2=MONTH(TODAY())+1 , but it doesn't work.
Can't you tell me what am I doing wrong
Try this, using only one condition:
all in the one CF condition
(remove not...Writing macro to format multiple worksheets?
Beginner in Macros, willing to learn a lot in short amount of time.
I am in need of information on how to write a macro that will format the
spreadsheets across multiple worksheets? [vs only working cell specific]
Unless you want to specifically write a Macro select the 1st sheet then,
with the Shift key pressed, select the last sheet. Now anything that you do
on onesheet you will be doing on all sheets. To Ungroup the sheet
right-click on a sheet tab and select Ungroup Sheets.
If you do want a Macro then use the Macro Recorder as a basis and then alter
In ...print excel graph
I cannot print an Excel graph. Other spreadsheet data prints OK. The labels
on the X and Y axes of the graph print OK. The graph title and inserted
regresssion formula print OK. The entire graph looks OK in Print Preview. I
have selected Chart in Setup. Changing from draft to normal has no effect.
I run Vista and Excel 97-2003
Is it one particular chart, or all charts, that have this difficulty. If
it's just one, I'd suggest you shrug your shoulders and build a new copy of
it from scratch, and delete the old.
Jon Peltier, Microsoft Excel MVP
please guide me to PRINT "comments" in an excel sheet.
goto 'File - Pagesetup - sheet' and choose your option for printing
"Deepak" <firstname.lastname@example.org> schrieb im Newsbeitrag
> please guide me to PRINT "comments" in an excel sheet.
CAN'T GET ANY OPTION REGARDING THAT....
Frank Kabel <email@example.com> wrote in message
news:#Ir1Wp0PEHA...print the tracking page
Is there a way to print the "Tracking" tab when I shedule meetings? When I
try to do this, the "Appointment" tab shows up as the page being printed...???
only with a screen print.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange...Comment font
Operating System: Mac OS X 10.5 (Leopard)
When adding comments to a Word document, it does not appear to be possible to change either the font type or size of the comment text. The font options within the Toolbox have no effect on comments, and the Track Changes category within Preferences does not provide any options. Is some other method available?
...Excel 2002 Comments Box
How do I change the size of the comments box?
If you're asking about the Insert - Comment comment box, you can drag each
side to wherever you want. HTH Otto
"DLC" <firstname.lastname@example.org> wrote in message
> How do I change the size of the comments box?
...Print First Page Only
In Outlook 2007, how can you tell it to print only the 1st page of a multi
page email? Am I blind or is the option just not there?
Thanks for taking the time!
Know thyself, know thy limits....know thy newsgroups!
"CJ" <email@example.com> wrote in message
> Hi Groupies:
> In Outlook 2007, how can you tell it to print only the 1st page of a multi
> page email? Am I blind or is the option just not there?
It is, b...How to avoid printing blank/empty "Document Properties"
I have created a Word 2007 Template and uploaded it to SharePoint.
On the front page of my Word template I have added a number of Document
Property Quick-Parts. I have one called "Title" and another called
The problem is, is that although all documents have a "Title" not all
documents need a "Subtitle"...so when I print the document instead of leaving
the "Subtitle" empty (because it doesn't have a subtitle)...it prints
How can I only print the "Subtitle" Document Property if...Insertted JPG. as comment. where is the source of picture
Howdy! I have inserted a picture as a comment to treat picture as
data. It seems to be working but where is actual copy of the picture
(assumeing I erased the original pics from hard drive). Thanks fo
Message posted from http://www.ExcelForum.com
It's stored in the workbook file. You'll see the size of the workbook file
increase as you put pictures in it.
mvpearl omitthisword at verizon period net
"ifew552 >" <<firstname.lastname@example.org> wrote in message
news:if...Comments in shapes
Using Visio 2003,
I would like to be able to embed (not sure that is the correct word) into
shapes in flowcharts, so that the comment is invisible until I roll the mouse
over the shape. When you roll over the shape, I wish to have the comment
I cant figure out how to do it.
On Wed, 25 Feb 2009 17:22:00 -0800, Carl
>Using Visio 2003,
>I would like to be able to embed (not sure that is the correct word) into
>shapes in flowcharts, so that the comment is invisible until I roll the mouse
>over the shape. Whe...Print selection
I'm new to Mac from Windows. I want to print the highlighted selection only. Can I do this?
No different here - select the content you want to print then choose
Selection in the Print dialog:-)
On 2/17/08 12:05 AM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <email@example.com> wrote:
> I'm new to Mac from Windows. I want to print the highlighted selection only.
> Can I do this?
Thank you Bob. I am quite certain I tried this last night and the selection option did not exis...Comments
I want to replace the comment function with a picture/chart that will only
show when i hover over the cell. Can this be done? please help.
Check out Debra Dalgleish's site:
> I want to replace the comment function with a picture/chart that will only
> show when i hover over the cell. Can this be done? please help.
Thanks for the help, can I also drop in spreadsheets and graphs. This website
only explain how to drop in jpeg.
hendrik...Outlook not printing headers
I am trying to print a hard copy of emails that i send.
When i attempt tp print the email only the body of the
email and my signature are printing. The headers (To:,
From:, Subject: etc...) are not visible. I don't think
this is an issue but just an option I am overlooking
somewhere. I have thouroughly searched the options from
tools and have had no success. Any Ideas?
...page setup landscape, but print footer in portrait mode
I have several pages that are being compiled. Most of them are printed in a
portrait mode, but several are in landscape. I would like to print page
numbers on all of them in the lower right hand corner. The landscaped pages
will be turned facing the right of course, so the page number needs to print
in the left hand margin turned 90 degrees.
not possible without VBA. You may record a macro while
- set the page layout for the first pages
- print these pages
- change the page layout (landscape)
- print these pages
In Excel 2000, I know you can print a worksheet's comments
at the end of the worksheet. Is there any way to capture
the comments and put them in a worksheet of their own?
...Cannot open macro file Quick Print Error Intermittent
I work wth a customer who, daily, uses the quick print feature in sales order
processing to expedite the exact documents and quantities they want printed
for each sales order accepted in customer service.
The problem they are having is that, intermittently, the end users, at
various times, will receive a "Cannot open macro file" error.
Now, they use this every day, every machine. Each machine is XP sp2 and
Dynamics is v9.0 with sp1.
I had thought there was something else going on that was causing the
problem, like macro security but that was not it. The users have full righ...Lifetime Planner Printing #2
The graphs don't print when printing the lifetime planner in 2004 on an hp
Does anyone know how to print an e-mail without the users
name showing as the header? In other words, I just want
the text of the e-mail, not my name at the top.
...format date in excel
Can you format a date in a formula to recognise the date only? i have a
column with the day number only and need to calculate the figure directly to
the right as this day number reaches todays date.
day cost to date
if todays date was 11th september, to date would be empty but if todays date
was 12th september, to date would have the figure £60.00 in it.
thanks in advance,
in the To Date column - assume it is C2
> Can you ...Hiding Comments from others
I want to add comments to a worksheet, but not allow others to read the
comments. I have seen that you can keep others from editing, but can you keep
others from seeing the comments?
But you may be able to fool some users by just:
and check the None option button for Comments.
(But you saw how easy it is to toggle that setting!)
Carla Hirschfeld wrote:
> I want to add comments to a worksheet, but not allow others to read the
> comments. I have seen that you can keep others from editing, but can you keep
> others ...Printing 03-30-10
How to print white on red paper using publisher 07
As far as I know there isn't a way to print white unless you have a white print
cartridge. Some printers have the capability to print white by inserting a white
ink cartridge in the black slot. Look at your model printer web site to see if
they offer white.
Mary Sauer MVP
"Stewart" <Stewart@discussions.microsoft.com> wrote in message
> How to print white on red paper using publisher 07
No can do. You print red...