File Format is not valid
I have an Excel SpreadSheet that was created last November which for some
reason we can no longer open. I have tried to restore from backup all the
way back into November but get the same error:
File Format is not valid
We had been able to get into the file up until recently. Thanks for the
try to open in a different version of excel like xl2002
"Patriot" <email@example.com> wrote in message
> I have an Excel SpreadSheet that was created last November which for some...Overwriting Cells
I cannot seem to get the "Alert Before Overwriting Cells" option to work.
Although I have the box checked I can overwrite non-empty cells without a
message. Can someone please help???
That warning is only for drag and drop operations. With the option selected
make an entry in A1 and in A2. Drag A1 on top of A2. You should get a
"Keith bedford" <Keithbedford@discussions.microsoft.com> wrote in message
|I cannot seem to get the "Alert Before Overwriting Cells" ...Conditional Formatting "Duplicate Values"
Operating System: Mac OS X 10.6 (Snow Leopard)
I am using Excel to enter pipe numbers, on my PC I can use duplicate values to highlight the cell if a duplicate value is entered. Unfortunately I have not been able to figure out how to do this in EXCEL 2008 on my MAC.
Not enough detail to answer.
Basically, you do it the same in Excel 2008 as you do on the PC. Search for
"duplicate" in the Excel Help and it shows two techniques.
Give me more detail on what you need and we can be more help.
On 6/06/10 12:45 PM, in article 59bb96fd.-1@we...how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel
I have a spreadsheet that the data, the date was input in Excel 2003 as
mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to
"dd:mm:yyyy"(31:12:2004)? I tried to change date
format from "Format Cells----choose "date" or "custom" and tried different
options, but they wouldnt change the data already in the cells. I have a
spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes
assuming date in E1
VB...saving values to cells
ok here goes...
what i was wondering is hard to explain so ill explain it in an smal
i have 3 sheets in my workbook, 'week1', 'week2' and 'total'
i enter the number 10 in cell A1 on the 'week1' sheet and the number
in cell B2 on the 'week2' sheet
on the 'total' sheet in cell C3 i enter the formula =week1!A1+week2!B
and it adds it obviously.
but i then want to delete sheets 'week1' and 'week2' yet keep the valu
13 in cell C3 on the 'total' sheet WITHOUT having to type it in myself.
ignore the macro part i...Cell formating #5
If one cell in a spreadsheet has a specific format (font, color, etc..) and I
have another cell that will equal that cell with an if formula, how do I
retain the formatting of the original cell in the cell with the result?
You would have to do that through conditional formatting
or manually format the cell with the formula in it.
A formula will only return a value from another cell and
not that other cells formatting.
>If one cell in a spreadsheet has a specific format (font,
color, etc..) and I
>have another cell that will equal that ce...What is the column width associated with cell borders?
It appears that there is a 1/2 pt border between columns.
Is that correct?
If I merge 3 standard 8.43 pt width cells (A1:C1) and wrap
text, the text wrap appears to be the same as if it were
one cell with a column width 26.29 instead of 25.29.
If I go to Format>Cells>Border the line style is
represented visually, but in Word the default line style
for a table border is 1/2 pt.
Also, is I use a cell border that is thicker than default,
does that reduce the space available in the cell or
increase the spacing between cells?
Thanks for your help,
The number format you...Conditional Formatting...Please Advise
If I have a row of cells B6:M6
A cell K6 which is "List" validated Yes, No
I would like the full range of cells B6:M6 to become Yellow, when the cell
is set to Yes from the list.
I have experimanted with the "Conditional Formatting" dialogue box, but
can't work out how to do this....I can only get one cell to change to
yellow....that being K6 if I select yes from the list.
Please advise the correct way for me to achieve this objective.
If you choose 'cell value is' in the first drop-down of the CF dialog, then
you can only adjust the current cell&...need help deleting space in cell with data
I have pasted a 1000 dates in the format mm/yyyy
However, when pasted in, the dates all have a space at the end of the
harachter. I want to delete that space so Excel recognizes field as a
The trim function seems to be only for text. Can anyone provide a
n? Any help would be great.
Thank you in advance.
andrewsolomon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24050
View this thread: http://www.excelforum.com/showthread.php?threadid=376583
...Can I reverse the order of data in a set of cells?
I have a column of cells filed with data. I know I can transpose the data 90
degrees, but is there a way to cut or copy the data in the cells and paste it
so the values are in the opposite order, i.e. a 180 degree difference?
Thanks to anyone who can help.
I am using Excel 2003.
One way, insert a new column or use an existing, number it from
1 - n (where n is the last index value you want to reverse the order of,
so if your column is 100 rows number the help column 1, 2, 3 - 100)
select both columns and sort descending on the help column
"salwitt"...excel will not print in color 2007
how do I get the colors set up on the page to print? My printer does color
and I did not have this problem with the 2003 version
Bill [email Wrote:
firstname.lastname@example.org[/email];699652]how do I get the colors set up on the
page to print? My printer does color
> and I did not have this problem with the 2003 version
Go to print properties inside excel print menu and check to see if the
printer is set to text only.
Dianne's Profile: http://www.thecodecage.com/foru...need to copy cell refs with different incrementation
I need to copy a range of cells, and some of them have references t
cells on another worksheet, but the cells with references are no
contiguous, nor are the referenced cells. I have tried the fill handl
to duplicate, and it does it partially correct, but not completely.
Example: B7 contains cell reference =eb!A4 (eb is the name of the othe
worksheet), and C9 contains cell reference =eb!B5. Cell B10 contain
the cell reference =eb!A8, and C12 contains =eb!B9. I want to cop
these six cells over and over down the page.
The problem is that I need the B cells to increment the number by thre
o...Can VLookup pull text format from data
I have a few VLOOKUP formulas that are pulling comments from a
previous spreadsheet. The comments have different text colors that
I'd like to replicate on this new spreadsheet. As it stands now the
VLOOKUP only brings over the comments in plan text.
Is there any way to bring over the text color as well? Maybe with
Formulas bring back values -- not formatting.
If you're using conditional formatting at the source cell, then you could use
the same rules in the destination.
If you're not using conditional formatting at the source cel...Remove Final Character from Cell.
I am trying to remove the final character from a cell with a find and replace.
the cell contents are like the following example.
needing to be 07APR07
But other cells in the list are already in the format of
I have managed to remove the * by using the tide ~ character. So I don't
know if there is a similar character to remove the last character only.
But am stuck with the last character. Can someone please help.
Microsoft MVP - Excel
"stuart block" <email@example.com...how to know the cell address in point units.
i am using ,expression.AddShape(Type, Left, Top, Width, Height)
Left, Top are point units,how to make the shape exactly in the place of an
or to say, how to know the cell address in point units.
No need to know the exact coordinates:
In article <eHmJTYjjEHA.1652@TK2MSFTNGP09.phx.gbl>,
"EXCEL�@NEWS&quo...spontaneous change of formatting
In the company where I work we are currently experiencing a strange
What happens is that randomly and spontaneously, the formatting of the
spreadsheets we use gets changed. Say numbers formatted like dates and
vice versa for example.
This has never happened in the past, and it is something occurring
over the last month or so.
The spreadsheets have macros however, I checked the code in depth and
there is no formatting at all; that is the formatting is just part of
the cells properties and that gets changed.
We are using Office 2007 and all the files are in .xl...Selecting a Range of Columns for Variable Rows
I want to do something like this:
Select a sheet
for row=3 to 17
select cells A:F
copy the cells
Select A2 on another sheet
Paste what I copied.
Shift down 1 row
I have verything down pretty well except selecting A:F for each row as it
I would appreciate any help you can give me.
It would be helpful if you post the code you have so far. It helps to fill
in the gaps in your narrative.
"BillR" <BillR@discussions.microsoft.com> wrote in message
>I want ...Need additional dimensions in Payroll Posting Accounts Setup
We desperately need the following dimension codes added to the Payroll
Posting Accounts Setup:
We place GP payroll in large government agencies and the current 2
dimensions (department & position) are woefully inadequate. These
organizations are complex and have multiple business units and funds for
which payroll transactions much be uniquely identified in the general ledger.
There are a lot of Microsoft and ePartners people trying to place GP in
public sector institutions but until this problem is solved, we are going to
be severely limited....#VALUE in cell but pop up function box show right number
I am using the XIRR funciton in Excel 2003. The cell shows #VALUE but when I
click on the function to open the Functions Arguement box, the number is
properly calculated in the 'Formula Results'.
Any experience this problem? Have a solution?
[I have been using Excel for financial valuation for years and I know what
the number should be so it is not a simple question of the wrong inputs -
like I said, when the Function window is up, the right answer is displayed -
I just can't read it in the cell which displays #VALUE.]
post yiour exact formula and the values in the re...Color Categorizing in a Shared Calendar
I am in responsible for scheduling events and appointments in several shared
calendars on Outlook 2007. We prefer to color categorize them and I was
wondering if there was a way to color categorize an appointment in a shared
calendar and have all users see that color category with exact name. For
example, we have set up a Conference Room as a separate user in our server so
it also has its own email address. Several admin support specialists have
access to this Conference Room calendar and we would like to color categorize
appointments in this calendar to reflect the different dep...Formatting percentage signs in Excel
Is it possible to change the size of the percentage sign that Excel inserts
in cells when the number in the cell is a percentage? If there are a lot of
percentages in a table, it is very difficult to read the numbers because the
percentage signs detract from the numbers. It would be good if there were a
way to get Excel to automatically insert the percentage sign in a smaller
If the cell format is set to Percentage you can't change the font sizes
within the cell or have two different font sizes. But, you can change the
cell formatting to Text and then change the percent...Conditional Formatting... #3
I have a table with two columns on a worksheet. The first column holds a
value that changes according to an Increment Value. So while sometimes the
column might increment by 5, other times it might increment by 10. The
column entries sometimes reach values up to 100,000. I want to use
conditional formatting to change the fill color (background color) every 100.
So if the increment is 5, then the first 20 rows will be gray, and the next
20, white, and so on. If the increment is 10, then each 10 rows, the color
changes. My problem is the second column. The formula here depends on...Can I add a picture to a cell?
Is there a way to add a picture to a particular cell? This way I ca
use it for look ups in other sheets. Thanks in advance for any help
Juan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=688
View this thread: http://www.excelforum.com/showthread.php?threadid=26356
not possible as pictures 'float' over the cells
"Juan" <Juan.firstname.lastname@example.org> schrieb im Newsbeitrag
news:Juan.1d6lzx@excelforum-nospa...Referencing using data in a cell?
I have a couple of problems. Firstly, is there a way to make the data i
a cell equal to the name of a worksheet. For example, if a worksheet (i
the case of the project in question) is called "43" how would I go abou
making a cell contain the number 43, or whatever the name of that shee
is. Not sure if this can be done, but its worth a try.
Secondly how can I refer to a cell on another sheet, but where the nam
of that sheet is kept in a cell. For example, in the same case again,
want data from a cell on sheet '42' cell 'AE6', so to make a cell i
the other sheet equa...Conditional Format Dates
How do I conditionally format dates that are more than one year old?
On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote:
> How do I conditionally format dates that are more than one year old?
In form design view, select the date control.
Click on Format + Conditional Formatting.
Set Condition1 to
In the next dialog box, write:
Change [ControlName] to whatever the actual name of your control is.
Please respond only to this newsgroup.
I do not reply to personal e-mail
On Thu, 17 Jan 2008 08:12:06 -0800,...