format problem #4
I have a file of 50000 rows and in column A in just 2 or three cells
i have a cell which show #NAME? but if u click that cell it will sho
=- vikram, how to get rid of this cell...i mean to say that how t
format that cell to a eadable format
Message posted from http://www.ExcelForum.com
Nothing wrong with the format (at least I don't think so), you just don't have a
named range or value of vikram.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------------------------...Format and layout protection
can I format a publisher document so people can alter the text, but leave the
formatting and layout alone?
No. If they can edit anything, they can edit anything. If you think about
it, consider what would happen if in editing the text, they needed a larger
MVP Microsoft [Publisher]
"Katie" <Katie@discussions.microsoft.com> wrote in message
> can I format a publisher document so people can alter the text, but leave
> formatting and layout alone?
You could put the la...Text formatted for Days and Dates
I am preparing an electronic diary.
For this I require two pieces of texts (for all the days in 2010) in the
I did the same for 2009...but for I forgot the steps and I do not have the
spread sheet with me now.
For this I have entered 01-01-10 in B1after formatting it as dd-mm-yy
In B2 I have enetered B1+1 and copied upto B365
Cells B2to B365 were formatted as dd-mm-YY.
Then in cell A1 I entered =B1 and formatted as DDDD. I got all the days in
the format "Friday"
Then I typed =A1+1, in A2 and copied upto A365.
I g...How do I change column labels from numbers to letters in Excel?
In Excel, my column headers somehow changed from letters to numbers. How do
I get the letter headings back?
For example, I can no longer reference cell C3 because the C is now a
Tools | Options | General | Check R1C1 Reference Style
"AllisonCincy" <AllisonCincy@discussions.microsoft.com> wrote in message
> In Excel, my column headers somehow changed from letters to numbers. How
> I get the letter headings back?
> For example, I can no lon...reduce decimal places of number used in formula
I use Excel 2000. I pulled a number with 5 decimal places into a contract,
reducing it to 3 decimal places. I then use that number in a formula to
figure a cost to be billed. I only want to use the 3 decimal number in the
formula. Is there a way for the formula to use the 3 decimals only without
having to actually re-type the number. I use this sheet monthly and would
like it to do it automatically.
If your number is in cell A1, when you reference it, use
So, instead of
MS Excel MVP
"CatzJ" <CatzJ@di...Maximum number of rows in Excel XP (2002)
Can someone tell me the MAXIMUM number of rows in Excel XP
or how high have you been? We are getting read to deploy
Office XP and this is something we are taking into
65536 rows per worksheet, absolute limit. Wether Excel is "filled" before
that depends on "rows with what". Pure text and numbers require no muscle.
Formulas are more demanding, how much is depending on their complexity.
Formatting like fonts and borders bloat the files and eats graphical memory,
so does controls and graphics.
I&...Update Values from a Userform
I'm trying to update some information in ms access from a useform in
ms excel. My problem is that I don't known how to do for the vba code
understand the values in my form...
This is the code:
Dim wrkSpace As DAO.Workspace
Dim db As DAO.Database
Dim qryDef As DAO.QueryDef
Dim qryNome As String
Dim strSQL As String
Dim strDB As String
On Error Resume Next
strDB =3D ThisWorkbook.Path & "\bd.mdb"
Set wrkSpace =3D Workspaces(0)
Set db =3D wrkSpace.OpenDatabase(strDB)
qryNome =3D "qryUpdate_Tax"
strSQL =3...numbering rows
i need to number my rows in a seperate column to count my inventory, but when
i filter my coulmns and do a custom filter my number column filters along
with the others even if the number column is not filtered???????????????
If I understand your question you want to see the visible rows numbered in
sequence? If so assume your data is in column A with titles on row 1, in the
column you want the row numbers to appear (say column B for this example),
enter the following formula in cell B2:
Copy this formula down.
"olga" wrote...Adding ship-to phone number to SOP documents
How can I add the phone number from the ship-to address ID to SOP documents
in Report Writer? Thanks.
Nevermind - found it in the Sales Transaction Work table.
> How can I add the phone number from the ship-to address ID to SOP documents
> in Report Writer? Thanks.
...How to Customize Formatting Palette
Operating System: Mac OS X 10.6 (Snow Leopard)
Is there any patch to go back to the 2004 layout, or to customize the formatting palette, without going back to Word 2004? <br><br>I just updated to Office 2008 (on Mac 10.6), from Office 2004. (I may go back.) Immediately I saw that Word 2008's approach to toolbars and the formatting palette violated two rules of usability: <br>
First: 2008's toolbars use up more screen space for the same tasks. <br>
Second: 2008 requires more keystrokes to use the same commands. <br><...Auto Numbering 09-24-04
I'm planning to implement MS CRM, and for all entities I want to keep the
prefix's as-is fot the auto numbering, but I would like to have the numbering
start with YYYY-001 each year so this year 2004-001, next year 2005-001 and
so on. Can this be possible from the client or is it possible to change this
feature in the database manually each year?
Hans Inge Letnes
The next sequence number is stored in the DB so you could definately "reset" it
each year after changing your prefix. Look at the organizationBase table for
MVP ...File Formats
Will my *.mny file from Money 2001 work with Money 2004?
Provided 2001 and 2004 are from the same region. i.e. both US or both UK.
Microsoft MVP - Money
"tcolby" <firstname.lastname@example.org> wrote in message
> Will my *.mny file from Money 2001 work with Money 2004?
To be precise, Money 2004 will upgrade your Money 2001-compatible file to
one that is Money 2004-compatible (assumin...Some Conditional Formats Not Available
I am using Excel 2000 on a network. Conditional Formatting for font typeface and size are not available under any circumstances. Has anyone else had this problem and/or identified the cause and/or remedy? Also the border options are severely limited (no bold or double lines). Is this normal, or is there something wrong with our Excel installation here?
this is normal!
If you need these kind of formats you have to use VBA
"Tom Nichol" <Tom.Nichol@jus.gov.on.ca> schrieb im Newsbeitrag
news:776377E5-6A73-442D-82D3-0A433714D046@m...Conditional Formatting (on OpenForm?
I have a form with datasheetview.
I want to add conditional formatting to some textboxes. I have to do this via
code, because it can be variable. (The expression compares the vendor-price
with the client-price.)
I add the conditional formatting on OnOpen-event. The problem is that the
fields have a NULL-value at that time, I guess, because it crashes on the
expression. What am I doing wrong? Via the dialogboxes this works, but via
code it crashes.
(Type mismatch error)
---- Code: -----
Set objFrc = Me.TCP_VENDOR.FormatConditions.A...format cells option not working
when i highlight some cells and try to format them nothing happends,
workbook and sheets are not protected, cells in question dot not have any
data in them at all, totaly blank!
if they are locked how can i findout? and how to unlock them?
OFF: Changes to Fill Color and Fill Pattern Are Not Displayed
Regards Ron de Bruin
"Steven" <email@example.com> wrote in message news:K3Yfc.2505$UG1.firstname.lastname@example.org...
> when i highlight some cells and...Anyway to show last 4 of cc number?
Is there a way to display the last 4 digits of a card on the account name
without manually adding it? I'm using 2003
No. I just make it part of the account name, as you describe. How many can
"Rob" <Rob@nospam.com> wrote in message
> Is there a way to display the last 4 digits of a card on the account name
> without manually adding it? I'm using 2003
...Counts number of entries per day in query
using access 2007, i have a query that shows
Event Type State Date/Time* DayCount
ALARM ACT/UNACK 01/01/2010 00:13:38 1
ALARM ACT/UNACK 01/01/2010 00:13:49 1
ALARM ACT/UNACK 01/01/2010 00:17:21 1
ALARM ACT/UNACK 02/01/2010 00:13:38 1
ALARM ACT/UNACK 02/01/2010 00:13:28 1
ALARM ACT/UNACK 03/01/2010 00:13:38 1
my SQL is
SELECT [Alarm Data Filtered by Date].[Event Type], [Alarm Data Filtered by
Date].St...Conditional Formating multible if statements
In CF condition 1 I have Formula is =IF(v11=TODAY(),X11="")
format is RED.
In condition 2 my formula is IF(V11=TODAY()+3,X11="")
format is YELLOW.
Columns V11=Date Due and X11=Date Complete
This CF works until I found out in some cases I can't put a date completed
because I am waiting customer authorization, so I started entering pending
and when I did that the CF went to the default. What I want to know is if I
enter pending in X11 can I still apply the above conditions until I enter a
date in the date completed column?
I am not sure why your existing equations...Auto Update Pivot Table and format wrap text
I have this code in a module, so as to refresh automatically a pivot table
in a sheet named "PrintSheet" it works fine in till I added some extra code
to format the cell D:D. What happens is now it tries to format every sheet I
open, I only what to format every time I click on the "PrintSheet" and
not in all the other sheets, and also need it to format from range D6:D not
the complete column.
I found out that the pivot table does not keep its format properties, so
when new data is added it need to be formatted everytime, that is why I like
to do this auto refresh/format.
...Is there a limit on number of rows?
Is there a limit on number of rows?
I want a spreadsheet that has a row for every day for many years.
That would be thousands of rows.
Is there a limit?
"Chris" <email@example.com> wrote in message
> Is there a limit on number of rows?
> I want a spreadsheet that has a row for every day for many years.
> That would be thousands of rows.
> Is there a limit?
In article <#e3UMXq#FHA.1256@TK2MSFTNGP15.phx.gbl>, CarlosAntenna
>65,53...count number of occurences on a particular date
I have a spreadsheet where I want to count the occurences of a value
on a certain date and then use the resulting information in a chart.
My spreadsheet looks someting like this:
Column *A* contains the ID of the defect
Column *B* contains the status
Column *E* contains the open date
Column *F* contains the closing date if closed.
An example spreadsheet would be:
123 Closed 05/12/2006 07/24/2006
100 Open 04/30/2006
125 Fixed 05/12/2006
180 New 09/22/2006
140 Closed 07/01/2006 07/24/2006
I would like to:
*a)* count the number of defects that are open on each dat...FORMATTING - hard questions
I have a cell which has plain text i.e. "Hello World" but between
Hello and World I press Alt-Enter to place the word "World" on the
second line so that the column width doesn't have to be long. But
when I reference this cell from another one, Excel not only shows a
weird ASCII character in between the words but also does not show the
two words on separate lines as in the original cell. Is thre a way
around this? TRIM and CLEAN did not do anything.
Also, I have a function that compares two cells =IF(A1=A2,"YES","NO")
and I would like to do a cond...Formatting unlocked cells
How to do formatting of unlocked cells?
I have locked certain cells and wish the user to have freedom o
formatting other (unlocked) cells. But once the sheet is protected
formatting etc. are not possible even for unlocked cells.
I am using Excel2000 and under protection password dialogue, the chec
boxes are as 'Contents', 'Objects' & 'Scenarios'.
How to solve the problem
Message posted from http://www.ExcelForum.com
You can't, this behaviour is by design in Excel.
"Bhuktar S >" <<Bhuktar.S.18lx28@excelfo...How to convert date field to number value
Hi, I need to convert an Excel date field such as "9/26/1964" to the
value of "19640926". Is this possible?
landj68's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28004
View this thread: http://www.excelforum.com/showthread.php?threadid=475075
Using a custom format for the cell you can rearrange the order. B
going into the Format menu then Cell menu. In the Number tab scroll t
custom and input "yyymmdd" without the quotes and the c...how do i enter numbers starting with zero in excel
i am trying to enter account numbers into my worksheet but when i hit return
it removes the leading zeroes, how do i keep them.
FORMAT / CELLS / NUMBER / TEXT
> i am trying to enter account numbers into my worksheet but when i hit return
> it removes the leading zeroes, how do i keep them.
Type a leading apostrophe - makes it text, which is fine for numbers you're
not going to use in arithmetic calcs.