Cell format newbie query
I have a worksheet where all the cells in a column are formatted as text but
there are numbers entered in the column.
Changing the format of the column, or even any individual cell, to number,
does not remove the triangle in the cell top left corner.
What should I be doing to fix the situation?
One quick way:
Select a blank cell
Select the range with data in it
Edit > Paste Special
You'll note that this converts the format of the selected range to
Norman Harker MVP (Excel)
Exc...Add an Image Object...
This is a multi-part message in MIME format.
I wants to add an image which is a part of my satellite assembly (means =
dll) to the excel sheet on the button click of my customized toolbar.=20
I tried using AddPicture method but the first parameter is a string path =
of the image file and I want to use image object. =20
How can I achieve this...
ch...Why is Actual Work updated when entering time into Work Field?
We're using MS Project 2007 and seeing that sometimes when time is entered
into the Work field for a task, that task's Actual Work is updated to the
same value entered in the Work field. This happens to multiple resources,
but only on some of their tasks and not on others. For example, for the
weeks of 1/24 and 1/31, whatever hours I schedule (enter in the "work" cell
in the Resource Usage View) for a given task also appears in the "actual"
The tasks are setup up differently. Some are Fixed Work, some are Fixed
Duration. I believe all have the e...Sum all rows above
I want to put into a cell the total of all numbers above that cell in that
column. I want to do this without specifying specific rows. In this way,
if a row were added above the total, it would be included in the total
"Robert" <email@example.com> a �crit dans le message de news:
>I want to put into a cell the total of all numbers above that cell in that
>column. I want to do this without specifying specific rows. In this way,
>if a row were ad...Re: Add Another Exchange Server
and see this, too:
"Susan" <firstname.lastname@example.org> wrote in message news:...
> with Exchange, you cannot restore a database from one server to another
> server, and have it work...EVERYthing would need to be the same, even the
> server name...and with Exchange 2003, you're talking about system state,
> metadata, and lots of other criteria...I do not really believe there IS a
> "poor man"s way of accomplishing this. The best thing you could do would
> to come up with a DR plan and...Multi-level Category Axis Fails with >100 rows of data
I'm having the same problem as posted on a few sites, one of which is below.
Is there any workaround, or plan to resolve this in the current version? Any
In my scenario, I'm building a Gantt chart style Promotional Calendar
organized by brand and then promotion name. The calendar can often have more
than 100 data points in larger markets. I've built a Gantt chart off of a
pivot table, with some VBA code to mimic functionality you'd get from sli...Chase checking 1 day late
The Money update for Chase checking is always 1 day behind the online
banking. Chase credit cards are same day. This makes Money somewhat
useless as I have to go online to check daily balances and activity. Any
Most likely they are updating their OFX server after (1 day) they update
Money (Microsoft) has no control over when (or how often) a bank updates.
"John Barnes" <email@example.com> wrote in message
> The Money update for Chase checking is always 1 day be...Excel 2003 spreadsheet. I enter the any number and it is entered.
If I enter a number into a cell it is put in like a decimal. For example, if
I enter 10 it is put in as .1 500 is entered as a 5
Goto Tools>Options and on the Edit tab you should see The Fixed Decimal
Places box checked. Uncheck it.
"maryu" <firstname.lastname@example.org> wrote in message
> If I enter a number into a cell it is put in like a decimal. For example,
> I enter 10 it is put in as .1 500 is entered as a 5
> Thank you
...Row Height Adds Blank Space at End of Text
We have a spreadsheet where the row height is automatically expanded to add
extra, blank space at the end of the cells. We manually adjust the row
height, save, close, and when we re-open, the space is back. There are no
extraneous returns in the cells. Anyone know how to fix this? Auto Fit does
not work. Thanks
...TURN $6 INTO $15,000 IN ABOUT 30 DAYS!!!!!! [0/1]
Post Size: 8.94 kB
Split size: 500 kB
This message is in yEnc format. If your newsreader cannot display this message,
please visit http://www.ydecode.com/ and download yEnc decoder.
more info on http://6eurocash.webs.com/
...How do I make all cells in a table the same height & width?
Is there an easy way in Publisher to take a preformatted table and change the
size of cells so that all are the same height and width?
Use grid guides from Arrange, layout guides or create your guides from the ruler
(arrange, ruler guides). There is no easy way.
Mary Sauer MSFT MVP
"jdmundy" <email@example.com> wrote in message
> Is there an easy way in Publisher to take a preformatted table and change the
> ...Can't insert row
I've got two spreadsheet with identical data types and, I thought, identical
formatting. One spreadsheet allows me to insert rows. When I try to insert
a row in the other one I am told that Excel can not shift non-blank cells
off the worksheet. I've never had a problem with this. What have I done to
TIA - Ange
you may have accidentically set your used range to the last row. Try
re-setting the used range following the instructions on:
and try again
Angela Byars wr...starting a cell with a /
Is it possible to do this?
I want one of my columns to contain a directory name, which in unix
starts with a forward slash.
I can put a space in front of it, but I'd rather not.
Thanks in advance,
the apostrophe won't display or print
"G. Mule" <firstname.lastname@example.org> wrote in message
> Is it possible to do this?
> I want one of my columns to contain a directory name, which in unix
> starts with a forward slash.
> I can put a space in front of it, but I'd rather not.
...How do I add annotation to a graph
Want to add text comments to a graph
display the drawing toolbar (view / toolbars / drawing) choose the textbox
object (or for a more exciting option, pick the love heart or smiley face!)
and type the text (note, if you're using an object other than the textbox,
to add text, right mouse click on the shape and choose Add Text).
"Steve" <Steve@discussions.microsoft.com> wrote in message
> Exel 2003
> Want to add text comments to a graph
Use the textbox feature...How will the Footer div stick to bottom of screen?
I've used CSS for the master page:
<asp:ContentPlaceHolder ID="head" runat="server">
<link href="styles.css" rel="stylesheet" type="text/css" />
<form id="form1" runat="server">
| . . .
| . . .
...Move a Column to rows
How can I move text that is in a column to rows
soddydj's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2571
View this thread: http://www.excelforum.com/showthread.php?threadid=39129
Try using Copy then Paste Special - Transpose
Copy the cells in the column you want to be in a row, go to the cell yo
want to paste the data and hit Edit, Paste Special and select Transpos
in the tickbox. Click ok
----------------------------------------------------------...Filter records by date in subform by date entered in mainform.
Hello, I've spent 3 days trying to understand what I'm doing
wrong.....Here is the summary of my problem.
I have a form named 'frm_EfficiencyStats' and a subform within the
form named 'qry_Total hours subform' (the subform is based on a
query). The form contains a text box (for date) which is bound to a
I would like to be able to enter a date in the text box on my form,
and display the records in the subform based on the date I entered in
the text box. The subform will only pull records from my table based
on the date.
Here are th...how to enter simple list and sum
using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?
if the list would look like this
the output would look something like
In B1 enter =A1
In B2 enter =B1+A2
Copy down to B5
Gord Dibben MS Excel MVP
On Wed, 16 May 2007 06:34:13 +0300, "John" <email@example.com> wrote:
>using excel 2002 with an xp sp2 system
>how would I enter a simple list of positive and negative...Linking Cells: Excel into Word Document
After reading through the help files for Excel 2002, it seems to me that
there is no way, except for programming, to have just a range of cells in a
worksheet be linked to a Word document.
Here is what I am attemping to accomplish: Using Word to create an extensive
document for a database proposal. Using Excel to document the all of the
required tables (since nothing has been created in Acces and I am new
databases), drawing diagrams with lines and other database objects. Would
like to be able to insert/link certain cells from a worksheet (which would
be many inserts/links) into t...Returning left part of cell before a character
I have a text file report that is not customizable. I import that into
Excel. There is a field where relevant data ends after the colon
character ":". Can someone help me with a formula I can put in column C
that evaluates the corresponding cell in column B and brings back all
text to the left of the colon mark?
freddy: 45345 sldf
jeff: 45422 fdflh
In this case I want to return the characters to the left of the colon:
Thanks in Advance!
You can use the formula
This wi...Microsoft Visual Studio Installer 1.1
Where can i download the Visual Studio Installer 1.1 for Visual Studio 6?
The link is not work.
I need to create deployement package in VS6.
"Martin" <firstname.lastname@example.org> wrote in message
> Hi all,
> Where can i download the Visual Studio Installer 1.1 for Visual Studio 6?
> The link is not work.
> I need to create deployement package in VS6.
It ...Paste rows in a table
Quite often I need to copy several rows of text to several rows of a
table. I copy the rows that I want to paste into the tables, highlight
the rows I want to copy to and click 'paste' or 'paste
special/unformatted text' or 'paste special/formatted text'. Only the
first word of each sentence is copied.
How can I get all the characters/sentences of each row copied into as
many rows in a table?
Thanks for reading,
Try using the 'table, convert text to table' command first. At the moment you
are copying all the selected text then pasting...Convert Column to Row
I have a table:
ID Price Quantitiy
1 1.00 2
I would like to convert the original table to something like this:
This is a small sample of a much larger table.
ID Measure Data
1 Price 1.00
1 Quantity 2
"banker123" <email@example.com> wrote in message
>I have a table:
> ID Price Quantitiy
> 1 1.00 2
> I would like to convert the original table to something like this:
> This is a small sample of a mu...Resource Units for Tasks entered in PWA differs than tasks entered in Project 2007
I have an ePM user asking why if he enters a project task in PWA does
it not check the resource max units allocation the same way as when he
enters a task in Project Professional.
You have a project where resource A is 50% allocated. When you create
a task in Project Professional for this resource, the resource
allocation is set to 50%.
Create a task under the same project in PWA, submit and approve the
Open project professional and view the task information for the task
entered in PWA, why is the resource allocation set to 100% instead of
50% set for th...1 Field and 2 Criteria
I'm new to Access but very fluent in Excel so bare with me on this.
What I have is a query I'm trying to create where I have a Problem
Code(numeric) and a Fix Code(numberic). Each of these codes have a Long
Description in a table just for these codes. However, this table has several
"TABL"'s within it. To get descriptions for a Problem Code the TABL field
must equal "101". To get descriptions for a Fix Code the TABL field must
equal "303". This is a problem because when I write the query I have each
code read out on a row but I can ...