Printing Barcode Font in RS2008
We have several reports that use custom barcode fonts, and these have been
working happily for ages.
We have recently deployed our reports to a sql2008 instance and have hit a
The Report Previews correctly in Reporting services (i.e. the user sees the
The report previews AND prints correctly in VS2008.
When we print from Reporting services the barcodes font is not displayed
(gibbersish characters are displayed instead).
We have checked that the users all have the barcode fonts installed locally.
We have also installed the barcode fonts on t...Conditional Formatting #33
I have a very large spreadsheet where I would like to use conditional formatting...I have the columns set up with times as follows
Arrival Time Triage Time Registration Time To ED Time DC Tim
Numerous people input the times and they are not always correct (people are DC before they arrive, etc.) There are about 3,000 lines for one months worth of data.
Is there a way I can put Conditional Formatting so that if Triage Time is Less than Arrival Time then it can highlight a cell?
This worked!!! This is going to save me hours of time each month. Thank you!!!
...Incorrect Date Format
Hello to all,
1. Excel 97 SR-2 and Windows 98SE, Short Date Format dd/MM/yyyy
I wrote a macro that imports dates (dd/mm/yyyy) and stock prices from an
Access database, then adds some formulas at the bottom of the data to
calculate highest and lowest prices and the corresponding dates.
Works fine, and the formulas correctly return the price and date (in
dd/MM/yyyy format, without needing to format the cells).
2. Excel 97 SR-2 and Windows XP Pro SP1, Short Date Format dd/MM/yyyy
The macro created in 1. above works fine under these conditions, but the
formulas that return the...Email address format with a twist
Exchange 2003 SP2.
We currently have email addresses in the form of firstname.lastname@example.org. We would
like to add an additional address of email@example.com and set it to be the
primary address. All new accounts would then follow this new format. I know
I can edit the recipient policy for the default domain to be
However, and here's the twist: we receive a daily .csv file from HR that
has all employees Given Name, Preferred Name, Last Name, etc. We then
programmitcally sync this with AD whereby Given Name goes into the First Name
field, Last Name goes into the L...caption font
I would like to know if it is possible to change by program the font
used in caption bar, menu, status bar, ...
Raymond Mercier wrote:
> I would like to know if it is possible to change by program the font
> used in caption bar, menu, status bar, ...
> Thank you
> Raymond Mercier
The status bar is a control, and like other controls its font can be
changed by calling its SetFont function with a CFont that you initialize.
But the caption bar and menus are drawn by Windows using the system
preferences. You cannot direct...FORMAT CELLS #10
I have a worksheet. Within that worksheet I have a few
cells which if I right click on gives me the menu options
and when I select the format cells nothing happens. While
it opens a dialog box for other cells.
I wanted to protect some cells by selecting the format
cells options. Can someone tell me what is happening and
why nothing happens if I select the format cell option ?
The only time I've seen this is when the original workbook was created in a
different program--crystal reports or Lotus 123.
I included a few "sacrificial" cells in my selection, made my...Conditional formating of cells
I have an array of numbers in excel. I want then to display as percentage
if I've selected "proportional" from a drop down menu. I want them to
display as a number (0.00 for example) if I select "absolute" these are the
only two options in the menu.
I'ved tried using the Format code help in Excel but I can't manuipulat it to
get it to work how I want.
Any help will be greatly apprecaited.
Let's put the drop down in column A and the data to be formatted in column B.
Enter the following in the w...How to write in Japenese font?
I want to write in Japenese font in Word. Is there any possibility to write
in MS Office 2003 with On-screen keyboard?
It's not a Word thing, it's a Windows thing.
Go to Start > Control Panel > Regional and Language Options, and try
to follow the tabs and buttons for "installing a new keyboard" (not
"installing a new language") They are rather different in XP, Vista,
In XP you need to check the box for "Asian scripts" (not "complex
There are many different input methods for Japanese; you can read
...Excel with Concatenate does not format date correctly
I am using Excel 2007. I want to use concatenate to combine employee
name with date started.
The date is not showing correctly.
The screen shows:
What do I need to do differently, so it says:
> I am using Excel 2007. I want to use concatenate to combine employee
> name with date started.
> The date is not showing correctly.
> A1=Jane Doe
> The screen shows:
> Jane ...If function with format
A1 "text" or "number" in red color
I want to print the value of cell A1 in Cell B1 with its format if above
condition is true. Is it possible ?
Use conditional formatting in B1. Set font color to Red when B1's value is
equal to A1's value. It won't matter if A1 is empty or has a value <= 0, as
it won't appear in B1 anyhow.
I was almost tempted to say to just set font color for B1 to Red. Seems to
me that would work (I'm almost positive it will), but there's probably
something I'm missing somewhe...Signature Fonts
We are using Outlook 2000 and need to disable the font
selection for signature blocks (we want to keep it at
Times New Roman 10). Is this possible?
Again thank you in advance for your help.
...I can't convert format number to format time
I'm using Microsoft Excel 2003. My problem is I want to convert format time
for example 13.26 to h:mm will becoming 1:26pm but when I'm using excel and
change that format the result is 6.25am. My final output i want to crete
chart Day vs time .I'm confius
Anybody can help me
you probably get 6:14:25 as result (or to be more precise: the
13-Jan-1900 at 6:14 hours).
Reason for this: Excel stores date/time values internally as numbers.
And the numeric values '1' represents onde day. So your decimal value
ins 'converted' to 13 days (starting from 1/1/1900...Contacts phone number format
I have a user trying to change the Outlook format for phone numbers to sync
with his phone. He wants to change from the default to something like
619-xxx-xxxx. Any ideas?
That's set up in Windows, not Outlook. It's in Phone and Modem options,
> I have a user trying to change the Outlook format for phone numbers to sync
> with his phone. He wants to change from the default to something like
> 619-xxx-xxxx. Any ideas?
"Mary" <Mary@discu...Formatting White Space
I have an xml document similar to this
<options attr1="1" attr2="2" />
<item name="a name" attr1="1" />
<item name="another" attr1="2"/>
<options attr1="1" attr2="2" />
<item name="a name" attr1="1" />
<item name="another" attr1="2"/>
During processing I have occasion to delete an item. So, using the DOM
interface I d...Is there font size limitation on antialiasing?
I made a program to display a character on LCD.
To apply anti-aliasing, I created font with ANTIALIASED_QUALITY flag.
[ CFont.CreateFont(... , lfQuality, ...) ]
The problem is like this:
When I displayed characters that the font size is larger
than about 680-pixel, the anti-alising is not applied on displayed character.
So I tested my program on the other computer. (My computer is Win2k, the
other is WinXP.)
At this time, characters that the font size is larger than 330-pixel is
with no anti-aliasing.
[ ANTIALIASED_QUALITY ] Windows NT 4.0 and later: Font is ant...font size in comments
Excel 2003 all sp and patches loaded
OS: Windows XP
Can you change the default font size in comments?
From Debra Dalgleish..............
You can change the font size of new comments by changing the settings in your
(Instructions for Windows XP)
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the default font used in
Gord Dibben MS Excel MVP
On Tue, 9 Jan...cell formating?
I posted this the other day and got the info on how to do it but i
can't fine the post?
So here it is again.
I have a cell that i need to add a sufix to how do you do this.
Lets say i need to add _BM
Here is a sample of what the cell looks like
Thanks for the help
(No private emails please)
"Steve_1_B" <firstname.lastname@example.org> wrote in message
> Hello Everyone,
> I ...Why Does Date Format Change on Chart
I'm using Excel 97 SR-2 on a Windows XP machine with the date format under
Regional Settings set to dd/mm/yyyy.
I have a simple line chart (on a chart sheet) drawing data (date on X-axis
and data on Y-axis) from three different worksheets, and am experiencing a
problem with the dates on it randomly changing format from dd/mm/yyyy to
m/d/yyyy. This is despite the fact that the dates in the worksheets are in
dd/mm/yyyy format, and I have formatted the chart X-axis in that format
also. Interestingly, if I click from the chart to one of the worksheets
then back to the chart, ...Default Fonts and Font Colors
Can anyone tell me how to reset the default font type and color?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from glomax <email@example.com>...
> Can anyone tell me how to reset the default font type and color?
Can anyone tell me what version of Publisher you are running?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
You cannot, you need to upgrade to Publisher 97 for all those excellent
Publisher 2003 has re-introduced some of...how to change default comment format in excel (2000)
I want to change the default font for comments. I know how to do this each
individual time but want to make the change permanent so I don't have to do
it each time I enter a comment.
Debra Dalgleish has some notes how to change the Font size at:
And she has a macro that can do more:
> I want to change the default font for comments. I know how to do this each
> individual time but want to make the change permanent so I don't have to do
>...Outlook 2002 Archiving Issue
I have about 6 clients running off a Win2000 SBS server.
The issue is that 2 of the users are unable to use the
archive function of outlook. They are both running winXP
and outlook 2002 with all the latest Patches from the
microsoft update site.
When you force an archive it looks like it is running
but when they look in their mailbox everything is still
there. If however you specify tomorrows date in
the "archive items older than" field it will then archive
everything. But until you select tomorrows date then
I removed one of the users mailbox from ex...Cannot see installed fonts in programs after installing with Font
OS 10.4 with current updates. Installed a TTF using the Font Book and it
shows there correctly. But when going into Word for example, type in text,
highlight it, click on the font format and the new font that was installed
will not show in the list. I have already tried deleting the font cache,
then rebooting and reinstalling the font thru the Font Book and just manually
copying to the /Library/Fonts folder.
Althought it sounds like you may already be aware of what it refers to,
below is an excerpt from;
http://www.macreviewzone.com/archive/hardcider/guestreviews/swope/osx_fonts.sht...Excel cond. formatting
I'm looking to format a series of cells conditionally, ie
if cell H7 reads "YES" then I want cells H1->H6 to all go
green. Conditional formatting will allow me to do one
cell, I know, but how do I extend this?
I need this to happen automatically, not thru Macro's if
at all possible.
for each of H1:H6 (can be done in one selection).
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"geordiebri" <firstname.lastname@example.org> w...Unstable fonts
My fonts are become unstable in Publisher. I believe manly those that I
downloaded from the internet. Sometimes I’m not able to use them at all even
though, they are still appearing installed. Or I just able to change part of
the text and if I add more to it the whole text changes back to the previous
In Word I do not have any problems with my downloaded fonts.
Any idea what’s happening and what could be the solution?
I appreciate your help.
Using: MW 2003, Excell 2003, PowerPoint, Publisher 2003, FP 2003,
There are some fonts that you can download that do not in...Formatting text in a cell
Is there a way to key text in one cell that is multiple lines? We would like
to be able to insert new lines where we want them.
Thanks for the help!!
Use the Formula Bar:
1. click in the formula bar
2. in the formula bar, move the cursor to the desired point of insertion
3. touch ALT-ENTER
4. enter the new line.
Gary''s Student - gsnu200855
> Is there a way to key text in one cell that is multiple lines? We would like
> to be able to insert new lines where we want them.
> Thanks for the help!!