Change default font format in Excel
I have an existing workbook with cell text entries in regular black font. I
want to make a number of additional entries in various cells in this
workbook, and I want all my text entries to be a different font format (bold,
red). Is there a way to do this automatically without highlighting each
entry I make and manually changing the cell format? Thanks.
Copy the code below, right-click on your sheet tab, select "View Code" and paste the code in the
window that appears.
MS Excel MVP
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Cou...Date format issue when submitting from a userform to a spreadsheet
I have a userform that I've generated which routes dates onto a spreadsheet
based on the users input. I am having a bit of a frustrating time with the
dates, it would appear that in the process of moving the date from the
userform to the spreadsheet some dates are switched/transposed. I'll give an
example. If someone enters 09/02/2004 on the userform excel seems to look at
09 and assume it is a month and transposes the dates to 02/09/2004(this does
not appear to be a US/UK format issues as I have already gone down that
road). However, if the date 13/09/2004 is entered i...Payroll Batch Number
Is it possible to obtain the batch number of a transaction after it has been
posted? I have been asked to create a report for our payroll department that
lists the batch number in addition to the transaction detail that is
contained in UPR30300.
No, the batch number is not available for reporting.
Charles Allen, MVP
"Jeff Majchrzak" wrote:
> Is it possible to obtain the batch number of a transaction after it has been
> posted? I have been asked to create a report for our payroll department that
> lists the bat...Money Upate SS Number
Al of a sudden when I try to update my portfolio ZoneAlarm warns that my
computer is trying to send My social Number. If I answer No I don't get the
Is this a new Feature or what.
I believe some Banks use your SS number as username. Nothing to do with
Money - it's what your Bank demands for you to use on-line services.
Microsoft MVP - Money
"PapaFrank" <firstname.lastname@example.org> wrote in message
news:KdOdnb00...Pivot Table formatting #6
When I format my pivot tables I have "preserve formatting"
checked under "PivotTable Options", and "Autoformat Table"
unchecked. Even so, I either lose portions of my
formatting, or different formatting is applied when I
refresh. Does anyone know what I am doing incorrectly or
have any other suggestions?
Other things to try -- if they don't work, you could record a macro as
you refresh and reformat the pivot table. Then, run that when you want
--Instead of selecting the cells to format the numbers, right-click the
field but...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...Custom cell formatting
I need to create a custom format for a series of cells that will begin like
I can't figure out what the code character is fora volitile potentially
Can anyone help me??
something like this might work for you but you'll need to put all the
leading digits in for the entry with the alpha character
"MDavison" <email@example.com> wrote in message
> I need to create a custom format for a series ...lost menu bar #2
HELP!!! The main menu bar is missing off my excel sheet
and I can't seem to find anyone to help me get it back.
The menu I am missing is the one that includes - File,
Edit, Insert and etc. I have tried...right clicking -
customize - toolbars, but I don't seem to have the needed
item. Anyone with suggestions - please reply...
if you right-click on the menu bar you should see an item like
'General'. Check this item
JoEllen OSBDC wrote:
> HELP!!! The main menu bar is missing off my excel sheet
> and I can't s...Auto formatting features: How do I align page numbers in publicati
I've got a problem with my publication. I can't align even page numbers to
the left without automatic moving the odd numbers to the left as well? Can
someone help me?
> I've got a problem with my publication. I can't align even page numbers to
> the left without automatic moving the odd numbers to the left as well? Can
> someone help me?
You need to create a two-page master rather than a one-page master. What
version of Publisher are you running?
Ed Bennett - MVP Microsoft Publisher
...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <firstname.lastname@example.org> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
I've always used MS Word as my email editor in Outlook. Is this possible in
Nope. I'm afraid that's only possible using Outlook.
In WLM you have to use the built in editor. Is there anything in particular
that's lacking from the built in editor that you're looking for?
"jrchambe" <email@example.com> wrote in message
> I've always used MS Word as my email editor in Outlook. Is this possible
> Live Mail.
In a Column 'A' sales Commission is calculated and resulta
is as 250, 200, 300, 330.
I wanted to format a cell with a Blinking colours where
value is 100 to 250, 250 to 300, 300 to 350 and 350 &
please help to format my sheet ... thanks
Getting your cells to "blink" is not in the standard Excel formats
What you want would require some extensive programming, certainly, ou
of my capabilities.
However, there are some great things you can do with Excel'
Let's say in column A you have numbers that are the result of formu...Date Format turn to Year
I tried to convert the date to YEAR and then the year plus 25 Years
=Year(A1) I'm getting the result 1900 instead of 1965.
I tried to add 25 years later to 1990 from 1965.
Your help would be much apprecated.
What's in A1?
Are you sure it's a real date?
> I tried to convert the date to YEAR and then the year plus 25 Years
> =Year(A1) I'm getting the result 1900 instead of 1965.
> I tried to add 25 years later to 1990 from 1965.
> Your ...Problem access variable in On Format
I'm using Access via Office XP Pro.
I am trying to format the Zip Code on the detail line of my report.
I have tried the following lines of code in both the On Format event and the
On Print event:
If len([PostalCode]) > 5 Then
if len(Me.PostalCode) > 5 Then
In both events and either code, I receive the error message:
Access can't find the field 'PostalCode' referred to in your expression.
If I put "PostalCode" as the source of the report's control...Opening and formating a CSV file?
Could someone remind me how to handle CSV files please? I had assumed
the Text Import Wizard would pop-up when I use File|Open, but the data
goes straight into the worksheet. (Presumably because it is not
'delimited'?) Without the Wizard at my side, how do I get each
comma-separated field in its own column?
Terry, West Sussex, UK
Try renaming your .csv file to .txt
Terry Pinnell wrote:
> Could someone remind me how to handle CSV files please? I had assumed
> the Text Import Wizard would pop-up when I use File|Open, but the data
> goes straight into the worksheet...How can I parse or Loop a list based on single field to Googlemaps
This is some code that will parse each sequential field [Point_#) into a list
"http://maps.google.co.uk/maps?f=q&hl=en&q=" & "from: " & Me.Point_1 & (" to:
" + Me.Point_2) & (" to: " + Me.Point_3)
The table/form is laid outlike this:
[Route_No] [Point_1] [Point_2] [Point_2]
5 North St, N1 East St, N3 High Road, W6
And the code will give this style of parsed list:
from: North St, N1 to: East St, N3 to: High Road, W6
That works just ...Formatting Cells in Excel 97
Sorry if I sound real stupid but is there anyway that we
can control the column formatting in Excel 97 like let's
say column A = GENERAL(6), column B = GENERAL(4), column C
= TEXT(18) etc?
Appreciate any form of advice, thanks!!
I replied in the programming group. Are you seeking a programming
answer? It's usually best to only post to one group, and include the
remark "Please tell me if I should ask this in another group."
On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <firstname.lastname@example.org> wrote:
>Sorry if I sound real stupid b...single user mode
I need to be able to establish an exclusive connection to the database
and do a restore to it. Nobody, can be connected to that database
prior to the restore. Also, I need to be able to schedule it to run
on a daily basis.
I tried putting that db in a single user mode and then do the restored
in a transaction but I got the error that the restore command is not
allowed in the begin tran commit tran.
How can I accomplish that?
tolcis (email@example.com) writes:
> I need to be able to establish an exclusive connection to the database
> and do a restore to it. Nobody, c...Numbering Recurring Items #2
Is it possible to number recurring items such as tasks and appointments? I
have several recurring appointments for lectures, and would like to show
them as "Lecture 1" in week/occurence 01, "Lecture 2" in week/occurance 2,
"The journey of 1000 miles begins with a broken fan belt and a leaky tyre."
"Duct tape is like The Force. It has a light side and a dark side, and it
holds the universe together."
"If the facts don't fit the theory, change the facts." -Albert Einstein
&...fractions to decimal
I want to have one cell call a cell that has a fraction in it that is
formated like so
I need it to be formated like
0'-0 7/8" so with the following code I can convert it to decimal.
the above code works when it is formated correctly
Thanks in advance
Is this a custom cell format, or just content stored as the text default?
if text, why not just search...format a CD
Hi, how can I format a cd+rw re writeable disc
...Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back.
I have tried doing everything in cell format etc.. anyone have an idea? it is
very annoying and adding loads of work to my project.
> Even when I open a brand new file. I input a number (ie 5)
> and get 0.05 back. I have tried doing everything in cell
> format etc.. anyone have an idea? it is very annoying and
> adding loads of work to my project.
...what is straight line depreciation and double line depreciation?
In article <928DC52C-D390-45C6-9847-693648A1A5DA@microsoft.com>,
MISSY <MISSY@discussions.microsoft.com> wrote:
"JE McGimpsey" <firstname.lastname@example.org> wrote in message
Quite a good article for wikipedia, but it misses one very important point.
The original purpose of charging depreciation to the P&L was to build up a
reserve in order to replace the asset when it became obsol...page numbering
I want to change the way the date appears in the footer and header.
Currently the date is day/month/year. I want month/day/year.
setting the date to a particular format is easy in a cell.
How do I set the date format in the header and footer?
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
jamessem, you could use a macro like this to do it
.LeftFooter = Format(Date, "mmmm dd, yyyy")
...Getting same number to appear over and again
Hi. I'm trying to change the E's I have entered in a column to 1's. However,
in lieu of changing them one by one, I would like to do them all in one fell
swoop. Any suggestions?
You could use find and replace.
Select all of your data. Goto Edit>Find
Find what:- E
Replace with:- 1
Do NOT multipost. See your answer in Excel group.
And do a google search for newsgroup etiquette!!
Do NOT multipost. See your answer in Excel group.
And do a google search for newsgroup etiquette!!
Do NOT multipost. See your answer in Excel ...