I have a large worksheet that I need to change the text to
all caps. I have tried using the UPPER function but it
will only work in one cell. How to I get the entire
worksheet to become all caps? Help!
> I have a large worksheet that I need to change the text to
> all caps. I have tried using the UPPER function but it
> will only work in one cell. How to I get the entire
> worksheet to become all caps? Help!
If you have trouble using macros you can do this ...Conditional Formatting #89
I need to know how to make a block turn RED if the date exceeds a year. Thanks!
Do you mean if the data exceeds one year from today? If
so, select the target cell, go to Format > Conditional
Formatting, choose Formula Is, and put:
Change $A$1 to your actual cell reference.
>I need to know how to make a block turn RED if the date
exceeds a year. Thanks!
Try this in - Conditional Format - Formula Is:
If E1 was ...Zoom percentage and formatting palette
Operating System: Mac OS X 10.6 (Snow Leopard)
1. How do you make sure that Word opens to a certain zoom percentage (140% for me) no matter what Word document I open? <br><br>2. How can I get the formatting palette to not be a floating box but to be incorporated right into the toolbar? <br><br>Thanks from a new user
On 24/05/2010 03:00, Jerdog201@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel 1. How do you make sure that Word opens to a certain zoom
> percentage ...report format portrait and lanscape
Is it possible to have one command to change report between portait or
If not, probably the best solution will be 2 reports.
Your information is great appreciated,
Your report is probably designed in portrait. This means it is designed to
print 8-1/2" - the left and right margins wide. If you change the printout
to landscape it is still going to print less than 8-1/2" wide on the left
side of the paper leaving more than 3-1/2" blank on the roght side of the
paper. To fill the paper you would have to write code to reposition and
stretch out each con...Community bank's new software doesn't export in my format
I am still using Money98 which does all of the little tasks I need (no
investments at my age). Two national banks provide exports in .qif format as a
matter of course, but when my local community bank went to new (better)
software, ".qif" was missing from the list of available export formats.
I wrote the bank and received word that the bank's vendor didn't support
Money98. The bank officer said: "My guess is the contract they have with Intuit
and Microsoft stipulates they not support it as those companies want consumers
to always upgrade their software.&...Question on Formats...
This ought to be quite simple to answer.
Is it possible to format the contents of a combobox?
On sheet1 I have text in cells A1 to A8 e.g A1 = John, A2
= Steve, A3 = Claire etc.
I have a combobox on a chart that displays those names
when I click the down arrow. The default is lower case,
black lettering. Can I make the names appear in bold and
green for example?
I have tried modifying the original names but that makes
no difference. If I right click the combobox and select
<Format Control> I cannot see a way to format my data
Maybe you can't do it. And I want to ...Convert Alpha to Numeric
I have two spreadsheet which I would like to compare. One has numeric data,
the other has the same data but the references codes have been entered as
alpha. Does anyone know how this can be converted to numeric?
Many thanks for your help.
Not sure, but maybe as a start, you could try something along these lines
using VLOOKUP and CODE() ?
Assume the sample (numeric) data below is
in Sheet1 cols A and B,
with the numeric refcodes in col A
And you have in Sheet2,
the alphas as the RefCodes in col A
...Query error after converting
I'm running Access 2003.
I have a working database. It seems as if the database is in Access
2000 format, because when I go to Convert, the 'Convert to Access 2000'
option is grayed out.
I need to convert this database to both Access 2002-2003 and Access 97.
I have this part of VB code, and it works fine in the current version,
as well as in Access 2002-2003 (after converting to Access 2002-2003).
Dim rstRoutes As Recordset
Dim strSQL As String
strSQL = "SELECT DISTINCT [Route] " & _
"FROM Highways_Info " & _
"WHERE ...Date on Template
I created some templates and am choosing to bring over a date to be shown in
the template when it is run. I have selected this attribute to be date only
and not date & time.
Every time I run the template it still shows date+time+time zone. Is there
a way to show only the date and not the rest of the data.
Thanks for any help anyone can provide.
...[more of a 'c' question really] Converting doubles to strings without getting scientific notation
I'm using _gcvt in a dialog to display a double, but when it gets
small the string appears in scientific notation
ie 0.02 become 2e-02
Is there another conversion routine I can use to prevent this? I have
a not terribly scientific customer who would prefer a straight forward
"Zardoz" <firstname.lastname@example.org> wrote in message
> Hello hello..
> I'm using _gcvt in a dialog to display a double, but when it gets
> small the string appears in scientific notation
...Excel page format changes
Operating System: Mac OS X 10.5 (Leopard)
Hello, <br><br>My client creates spreadsheets for her boss. She pushes the boundaries to get things to fit on the screen. <br>
Uses A4, margins at 1.5cms and scales to 90%. <br><br>When her boss receives it by email the margins go to 2.5cms, scales to 100%. They have the same versions 12.2.4 and Leopard. They are just about to be upgraded to Snow Leopard. Any idea why this could be happening? Thanks.
...converting from text to numerical number
I have a spread sheet of entire year schedule. The format as following:
1 2 3 .... 31
row 3 Jan
row 5 Feb
row x Dec
I would like to replace column 1 up to Jan to 1. Replace the cell below Jan
to Feb to 2. etc.
Would anyone help.
Thanks in advance.
You could select cells A1:A3, type a 1, then press Ctrl+Enter
Select A4:A5, type a 2, and press Ctrl+Enter
And so on, till all twelve months are done.
> I have a spread sheet of entire year schedule. The format as following:
> 1 2 3 .... 31
&...Calculate Dates with If Then Else Statements
I need to calculate total years’ full time experience (i.e. 2.5 years, 3.25
years, etc.) in an Access 2003 database form. This is what I am trying to
do: If the Full-Time End Date is Blank, use Today's Date, ELSE if the
Full-Time End Date has a Date, use that Date.
Separately, these two formulas work:
My problem is writing a statement to calculate using the END DATE if one is
entered, or NOW, if there is no end date. I have tried many combinations,
but can’t ge...two decimals - remove percentage sign
I have percentages that i'm displaying in graphs with data labels. I'd
like to remove the % sign so it is easier to view the data labels
because the graphs are small, and i'd like to do it with custom
formatting because there is quite a lot of data that i dont want to
convert to whole numbers.
I think the best way to do this is to somehow use custom formatting in
format cells -->number-->custom to multiply by 100 and display it that
way. is that possible?
Thanks for the help!
...OL 2003; Question about two default attachments in HTMLMessage Format
This is a multi-part message in MIME format.
Outlook 2003, XPP SP2=20
When I send an e-mail message in HTML message format, the recipient =
(even when I send to myself) also receives two default attachments, =
image001.png and image002.png. The first image is a what I would guess a =
Microsoft ...Filter Date
Hi, I have a form which contains a listbox (holding the values Process
Date and Quantity) and I have a textbox which displayed the current
month. What I want to do is when I click on a command button
(cmdMonthDown) and the textbox value changes from May to April I want
the values in the listbox to be filtered so that only those values are
disiplayed that were entered in April.
If I'm not making sense please let me know otherwise your help would
Reference the text box as a parameter in the list box's RowSourcee, e.g. if
the text box shows the month name in fu...Task start/end dates from MS project to Workspace site
We are currently running MSPS 2007 with WSS 3.0. I am trying to create a list in one of the project work spaces. I would like to auto-populate two columns in that list with the start and end date of certain tasks from the Project Plan in MS project. I am thinking we can do this by linking these columns to the the project SQL database fields. So,
1) Do I use the published SQL databse for this?
2) Which fields in the SQL database would I have to link to get the Start and End dates?
EggHeadCafe - Software Developer Portal of Choice
AutoList in ASP.Net
http://www.eggheadcafe.com/tutorial...Date Format when incoming date can be 0
I have a date fiels yyyymmdd which can have a value of 0 or a valid date in
Excel displays the 0 date as 01/01/1900 and the non zero dates as expected.
Cant figure this out , any help would be appreciated.
Excel uses a sequencial number from either 1/1/1900, or 1/1/1904 (depending
on your options) as the date value
for Example 6/3/2005 is 38506 using the 1/1/1900
if the cell is formatted as a date it is responding with the date it thinks
If you want the cell to display a zero
"DP NY10601" wrote:
> I have a date fiels y...conditional formatting: separating rows with differing values
Need help with conditional fomatting.
What I need:
I got a worksheet with 950 rows and 5 columns. The first row contain
the headers. Columns A, B, D and E contains unique values. But the
column C contains text values which repeats sequentially for 6-7 rows
and changes thereafter. Now I want to put up a line (using border)
through the whole row dividing this transition row.
Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so
on till 2 consequtive values differ. Now divide the 2 rows using the
border formatting option in conditional formatting dialog box.
So...how to calculate the substraction between two dates
i have two cells ,in which there are two dates.
(for instance ,one cel l 08/02 ,the other 07/30)
if the gap of the two dates is 2 days , something will be set to do.
but it is difficult to judge the the substraction between two dates
any good ideas.
Perhaps this might be of help ..
Assume the *dates* "2-Aug-2004" and "30-Jul-2004"
are input in A1 and B1, and
A1:B1 is custom formatted as: mm/dd
viz. it'll show as:
In A1: 08/02
In B1: 07/30
Try in C1: =DAY(ABS(A1-B1))-1
Format C1 as: General or Number
C1 will return: 2
i.e. the number of days...Converting a number to Hour & Min format
I am attempting to take a basic number, say 2000, and convert the number into an hour and minute format (i.e. 33:33) only. Everytime I use the custom format tab or the time/date tab I get a date included or an AM/PM setting. Any ideas or suggestions? Thanks in advance.
For any number to be converted into time format you need to divide tha
number by 24, since Excel time code is 24 (hr) code. then you forma
the divided answer (83.33) into time, you will get 8:00
Message posted from http://www.ExcelForum.com
In article <...Date Range
When I want the date rage appeared on the report header, I use textbox and put
(qry criteria) in its recordsource. It works fine.
However, For this time, I got a message like this ‘First([Between [From this
date] And [To this date]])"
Is there something wrong with the qry criteria?
Would you please show me how to fix the problem?
It's very hard to understand the crtieria, can you post the full SQL
What is the First in the beginning?
Why there are to square brackes in the end And in the beinning?
First([Between [From this date] And [To this date]])"
T...What is a good program to convert pdf files to word?
I want to be able tosave pdf files as word files.
PDF is essentially a graphics format. How well it can be converted to Word
format rather depends on what it contains. The most reliable method is to
use OCR software, such as Finereader.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>...how to convert msg files into wav file.
i have recorded some voice on a pocket pc i have. i transfered that t
the pc. now these are *.msg files and wanted to convert the files int
wav files. is there a way i can do this.! i have been trying for quit
sometime and have been unsuccessful.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
...formatting background on CD label
How do I get the background to be one continuous picture and not duplicates
of the same picture? I tried to look in help but couldn't find anything. It
looks really ugly.
> How do I get the background to be one continuous picture and not duplicates
> of the same picture? I tried to look in help but couldn't find anything. It
> looks really ugly.
Instead of using the "background" option (which is more designed for web
pages), insert the picture (either on the Master Page, or on the
publication page and send it to the back), and resize it to fill t...