columns show as numbers
I just noticed that all of my columns now show up as numbers instead of letters, which makes it difficult for entering formulas - how do I get the columns back to letters
Tools, Options, General, (uncheck) R1C1 reference style
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"jbv" <email@example.com> wrote in message news:B43F64D5-7296-43AB-A137-98F623BC5236@microsoft.com...
> I just noticed tha...Dependent Formatting (Text or Numbers
I am attempting create formatting for an object based upon the value
displayed. If the value is six numbers entered without spaces (Ex. 123456),
then the formatting should be "##-##-##" (Ex. 12-34-56). Otherwise, the
object must allow regular text. I have tried several different methods but
with no luck. Below is my most recent attempt. I tried inserting it into the
"lost focus", "on change", and "after update actions". Many thanks in advance
for helping clear up a headache.
If Me.AccountCode1 Like "######" Then
Me.AccountCode...Print routing number and account number on checks
Will money print the routing number and account number on
the bottom of the checks?
I have been unable to get it to do it.
There are some workarounds and some reasons, but in general the best answer
is to just buy stock preprinted with this information. The details are
posted from the FAQ on a regular basis--in the fact week, if I recall
correctly. If you want to understand and cannot find the postings or the
FAQ, post back.
"Phyllis Hershberger" <firstname.lastname@example.org> wrote in message
> Will m...Journal Entry Number Format GP9
Can i change the journal entry number format options? this is what i wanto to
approach, The company im working now, wants to have a control number for all
journal entries by setting up a journal entry number format
for example en the month of january they want to have as follows
01010000 this will be the journal entry number displayed on the window then
01 means month, the following 01 means the day and the remaining 0000 are
the transaction sequence for the day. so that january 02 will be 01020000 and
if we created 345 journal entries in august 27th the number is 08270345.
Is it possible...Serial Numbers and Work Orders
Is it possible to associate an item with a serial number in a Work order,
BEFORE TENDERING THE TRANSACTION?
Many times a retailer would want to set aside a particular item that is to
the customer's preference or which may need to have work done on. Is there
any way to provide the serial number while the item is being addded to the
Work Order as opposed to when the item is being finalized?
Our work around is to type the serial# into a comment for the item. We
always print our work orders before converting them, so then we will know
what the serial# is. I woul...XML & Decimal Numbers
A couple Q's , so I've come to the experts<g>.
1) I need a definitive answer to the following debate. I've got a couple
developers who disagree on the following question. We've got an XML file of
numerical data results where it could contain values such as:
<RESULT>0.12345</RESULT> when created in English, but it could contain:
<RESULT>0,12345</RESULT> when created in another language... such as German
or French. One developer claims this should be perfrectly allowed, the other
claims you can never use commas in XML files for content a...How do I format a negative number in parenthesis?
The format cell does not alllow for parenthesis around negative numbers with
decimal places? How can I set this up?
Use a custom format like:
pinmaster's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=626
View this thread: http://www.excelforum.com/showthread.php?threadid=49856
click on the cell
choose format / cell
this should give you what you want.
julied_ng at hctsReMoVeThIs dot...Outlining
We are trying to import an outline, usually two levels, with an occasional
third. The original is either WordPerfect X3 or MSWord 2003. These two
program produce outlines differently. WPX3 is superior by the way. But I
digress. We want to bring that outline into Publisher 2007. We get the
text but no numbers. We used Publisher 2000 and got the numbers until we
updated to WPX3 and Word 2003. Once we made those changes no numbers. I
have tried to import text. I have tried copy text. And I have tried
creating an outline from scratch and cannot get two level outlines. Is such
a...prevent Excel from EVER automatically converting numbers to dates
in Excel v. X for Mac how do I permanently prevent Excel from EVER
automatically converting numbers to dates. Formatting individual cells
as text will not work in my applications. I need to disable this funtion.
Not possible - there's no preference option to turn this off.
Instead of preformatting as text, entries can be made with an
apostrophe as a prefix:
You might be able to use an event macro to change it back
retroactively, but that depends on knowing what format the user
entered it. For instance,
3/4, 3-4, 4Mar, mar4, etc
will all be interpreted as 4 Marc...PO number on Invoice
1. Is there a way to enter a PO# in RMS so that it appears on the invoice?
To do this, we use the 'details' option on the POS screen when creating the
> 1. Is there a way to enter a PO# in RMS so that it appears on the invoice?
...making a cell fixed number to a input number
I am doing a caclculation. Some of the time I want to do it with a
percentage and sometimes with a dollar amount. If I punch in a dollar
amount I want it to come up with the persentage. If I type in the
percentage I want it to come up with the dollar amount. How can I make
the formula stay in a cell even if I punch something in.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
And how do you tell .20 (%) from .20 (cents)
"fwday" <fwd...Number of contacts?
What is the max. number of contacts that can be in a folder. I have outlook
jsanders <email@example.com> wrote:
> What is the max. number of contacts that can be in a folder. I have
> outlook 2003.
...Filter for 225 or 233 numbers #2
Hi Julie and Frank
I have just tried your formulas and they dont seem to work I the no.
stored as text due to a 0 being at the front of them
when i convert to a no. Julie your formula only dispays false
Frank your formula doesnt display anythign in the cell next to it it
any ideas what am i doing wrong
hoganc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1498
View this thread: http://www.excelforum.com/showthread.php?threadid=26686
should work if you leave t...limit on number of characters?
I am using Excel 2003, SP2. I just exported the results of an Access query
to Excel and found that the data in one of the fields is being truncated
after 255 characters.
I can type more than 255 characters in a cell. Does anyone know how I can
export more than 255 characters into Excel?
I don't speak the Access, but Debra Dalgleish once posted this:
Or, transfer the data with code. Use the TransferSpreadsheet method to
send the data, and specify one of the later Excel versions:
DoCmd.TransferSpreadsheet a...Generate a unique number of list
I have a list of number which some is repeated, how can I regenerate a
list with unique number. e.g
Thanks for any one who can help.
Terence Chan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26963
View this thread: http://www.excelforum.com/showthread.php?threadid=467164
Mark your range of data, Data>Filter>Advanced Filter and Select Unique
Copy the data to a new location.
Rega...missing Check numbers
When printing of a Vendor Cheque register report, there have been the odd
cheque number missing. Why and how does this happen?
...Number of months between 2 dates
I can not remove this double thread ... sorry
...red numbers in balance column and account is not overdrawn
i just opened money and my checking account to balance my
account and in the balance column it was showing red in
parenthesis which i believe means negative balance for
many entries. my account is up to date and is always in
the black. why now is it showing red in some entries? it
has never done this before and the only thing i have done
different is opened different reports to see what they
looked like. i was still able to balance my account and
it shows in the black. there are a few entries in the
black but most enteries are in the red and seen to be
...Show number of rows pr element in a pivottabel
In Excel 2007 I have a pivottabel showing
In Column B I have (and collapsed) the projects behind the Turnover :
A B C
Projecttype Project Turnover
Maintenance Proj 1 5
Proj 7 95
Repair Proj 5 7
Proj 10 10
Proj 12 33
I would like to show the number of project (2 Maintenace and 3 Repair)
in ny Privottable. Either in a new column or somehow else ...Reading Numbers in Words
I need a formulae that can read figures in a specific cell e.g 123 and change
them into words (One Hundred Twenty Three)
Tarig, have a look here,
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Tarig" <Tarig@discussions.microsoft.com> wrote in message
>I need a formulae that can read figures ...Formatting cells for phone numbers
Hey, im looking to format a number of cells into a phone number format
I have a rather large excel spreadsheet of around 900 phone numbers
they are currently in different formats such as:
+44 0800 7777777
+800 (900) 666666
These are obviously just example numbers and not real ones, as you ca
see they are all over the place and in the wrong format that i nee
them in. Changing them all manually would take me forever so ive trie
to create a custom formatting rule to have them represented like this:
+44 (800) 888888
So basically they must all begin with +44 then the n...Saving custom number format
1) I am trying to save a custom number format for e.g. ###,###,000.000
But when I open a new file this format is not available. Why doesn't it
gets saved? (excel 2002)
2) My home computer has recently been upgraded to the latest version of
excel. But I used to hit Alt + F and then C to close a file in earlier
versions. This no longer works! I have to hit Enter key after pressing
the "C". Is it a bug? or am I missing something?
Custom formats are saved with the workbook.
To have these available for all new workbooks, save a blank workbook with the
custom formatti...Trouble formatting page numbers
I have a document that uses a 2 page master, both pages have a page number
centered in the footer. When I switch from the Master to the publication
pages, the page number moves over to the outer margin of the page...I hae
tried deleting the footer and re-insterting, copying from a file that the
footer is centered correctly, etc... nothing seems to work for long. Any
You can move the page number text box anywhere on the Master Page, format it
right, left or center. It behaves the same as any text box.
I have a sheet with NO calculations. I would like to
manually outline (I am new at this feature) so repetitive
data collapses. Let's say my data looks like this:
Acme Co. North
Acme Co. North
Acme Co. South
I want it to collapse to show only unique names, like
+Acme Co. North
Acme Co. South
When I manually outline each group, they all combine to
one big group. Any hints?
How about using the subtotal feature from the data menu?
Just select "count" of "co. name" or whatever.
>...Checking cell for Number
I have about 200 numbers in column A. I would like to enter any number in
Column B. In column C I would like, it to show if the number is used or free.
can this be done with a if statement?
If you have a list of numbers in Column B that you'd like to check,
enter the above formula in C1, and copy and paste the formula to your
other cells in Column C.
Hope this helps!
In article <E5CA9196-6FCF-492C-B488-1B7E431720CF@microsoft.com>,
Lee <Lee@discussions.microsoft.com> wrote:
> I have abou...