How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Formulas do not work in excel.
Formulas have been working but suddenly they will not add or subtract unless
we click on the target cell. This happens in all excel files even in new
Try going to tools-option-calculation and click automatic if it is on manual.
Let me know if it works.
> Formulas have been working but suddenly they will not add or subtract unless
> we click on the target cell. This happens in all excel files even in new
...Not plot a data series in a chart but still display in data table
MS Excel 2007
I've somehow managed to display only two data series on my line chart. They
still display in the data table. How did this happen? More importantly, how
do I reverse it. I don't want to recreate chart.
I see the data series not plotted on chart in the Chart Elements and when I
select the series, the source data is highlighted; it's in the data table.
How do I make it visible?
HAve you perhaps simply formatted the data series as "no line, no marker"?
If so, you can format series, add some color.
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...How do I prevent duplicate entry of a sku in a data table?
I want to keep folks from entering the same sku into a table (i.e. like data
validation does for other parameters).
Assume that you want to restrict the users from typing the duplicate values
in A Column.
Place the cursor in A1 cell and press Cntrl+Spacebar which will selecte the
A Column. Keep in mind that the active cell should be A1 cell. (Active cell
will have a white background after selection also)
Data >>Validation>>Settings>>Validation Criteria>>Allow>>Custom>> and in
Formula paste this =COUNTIF(A:A,A1)=1
Data>>Validatio...PROTECTING FORMULAS #2
I have a sheet where when opened, it runs an auto macro to move cell
contents from one
column to another and uses a formula to do some calculations. If I select
the columns I want unlocked, then protect the sheet and try to run the
macro, I get an "run time error 1004 unable to set the numberformat property
of the range class" When I debug the following is highlightd
"Selection.NumberFormat = ";;;" " I was a Lotus user and in Lotus I
could select a range of cells or columns to protect, I'm having a hard time
to get Excel to do the same.
I appreciate th...Change operater in Excel formula
depending on a certain circumstances, a formula must change from "X = Y" to
"X <> Y".
Can this be done (e.g. using "if", or otherwise) ?
Thank you in advance.
You didn't give us a lot to work with, but I think you are looking for
something like this...
=IF(<<your condition>>,<<formula with x=y>>,<<formula with x<>y>>)
Rick (MVP - Excel)
"H.G. Lamy" <Enterplan@web.de> wrote in message
news:upAoGxlhKHA.6136@TK2MSFTNGP04.phx.gbl.....How do I unlock my keyboard on Word?
Anytime I try to type on Word, a little text appears at the bottom that says:
"This modification is not allowed because the selection is locked." I have no
idea what's wrong. Help!
it is a trial version that has expired
the application has not been activated
> Anytime I try to type on Word, a little text appears at the bottom that says:
> "This modification is not allowed because the selection is locked." I have no
> idea what's wrong. Help!
...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hfirstname.lastname@example.org> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Worksheet name in cell formula
I asked this question a while ago and got a prompt answer which I thought
was what I wanted but alas its not...
I want to be able to change my worksheet names.....ie: from Sheet 1, Sheet
2, etc etc.....to something more meaningful.....eg Sales, Expenses....etc
etc.... and have these changes reflect on the worksheet.
For example, I might want Sheet 1 Cell A1 to say.....This is the Sales
worksheet (assuming I have renamed it to Sales).
The answer I was given some time back worked.....but it changed the formula
on every worksheet to reflect the name of the last changed sheet.
By this I mean.....Updating a table
I have query that relates to a table and i want to be able to automatically
insert a comment into a range.
I.E Table column is called Report name. I want to open the query and have
it ask me the name of the report. When i enter it i want it to
auutomatically enter the name in the column so that all the other information
that i add afterweards is associated with the report. I then want this info
to save when i exit.
Can anybody help?
...How do i get Harvard style referencing in word 2007?
I am currently writing my Dissertation for my University Degree. I have
found the citation feature extreamly usefull as it automaticaly adds the
referencing to my work.
However, after speaking to my project supervisor, she has informed me that
the citation style will not be acceptable as it is not "Harvard" style.
I was wondering if there is an update that i can download to enable to have
harvard style referencing in my work.
I would apreciate any help that you can give.
I suggest you speak again with your supervisor as there is no such thing as ...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Colour numbers within my formulae
I have been playing around with the '&' function, allowing me to mix text
with calculations and cell references.
I have the following at the moment:
="Of the "&TEXT(J954,"�#,0.00")&" made this year, I have managed to save
Which gives me a cell displaying the following:
Of the �0.00 made this year, I have managed to save 0.0%
What I would like to do is show the numbers (�0.00; 0.0%) in the colour
blue. I don't want to add conditional formatting, just apply a colour so
t...Font in Formula Bar
I just started using Microsoft 2003.
In Excel, I can't read text that is in the Formula Bar because it is i
a weird small font. I looked everywhere to figure out how to change th
font in the Formula Bar, but i can't find it anywhere.
What font does it use? Is it based on an option in Microsoft or is i
based on something to do with the Desktop settings...i've looke
everywhere for an answer to this.
Thanks for any help.
jdkuhndog's Profile: http://www.excelforum.com...protecting formulas
I am trying to find a way to protect formulas on a spreadsheet whil
still allowing users to put in new data. Is there a way to do this?
am using excel 200
Message posted from http://www.ExcelForum.com
unlock the cells where you want input and then protect the sheet with a
Format | Cells... | Protection tab | Locked = false (not ticked)
"Cherilyn >" <<Cherilyn.email@example.com> wrote in message
> I am trying to find a way to protect formulas on a spreadsheet while
...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...financial excel formula
Trying to use excel to determine the % return on a stock from the tim
you purchase until you sell, adjusted for time. ie., key in Pv o
money today; input Fv or (the selling price); enter the amount of tim
expressed in months or years (N); calc the rate of return %? p
N 3 years
% return =??? using a texas instruments ba-35 calculator th
answer is 13.96%. Can't get this out of excel, any suggestions
Message posted from http://www.ExcelForum.com
The financial function follow the rule that incoming and outgoing money are
different in sign. Hence...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <firstname.lastname@example.org> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...Change to formula
I am using this formula to display the current date on a sheet, I require it
to show the actual day before, what do I need to change.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"bbc1" <email@example.com> wrote in message
news:9F920C16-159A-478D-AEC3-81BD6ABC5...How do you insert page numbers larger than 1000?
I have my purchase orders set up as a Publisher document. When our
organization upgraded from Publisher 2000 to Publisher 2002, the new version
set parameters on the page numbers. This was one of those things that worked
just fine in the previous version... Does anyone know how to turn it off or
Hi mregen (firstname.lastname@example.org),
in the newsgroups
|| I have my purchase orders set up as a Publisher document. When our
|| organization upgraded from Publisher 2000 to Publisher 2002, the new
|| version set parameters on the page numbers. This was one of those...How to chart a series of formulas?
Hi, does anyone know how to chart a series of formulas?
I currently chart cells in column C. Each cell in column C contains
a formula - "=A1+B1", "=A2+B2", "=A3+B3", etc.
I would like to do away with column C and just get the chart to
calculate the values that are being displayed automatically. How can
you do this?
Charts aren't that smart, and worksheet ranges are pretty cheap. Compute the data in
the worksheet, and plot the column with the formulas.
Of course, you could name your ranges (Adata and Bdata) by selecting each range,