PUTTING NUMBERS IN A CELL
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN
Please turn off the CAPS Lock, more than two lines would
be extremely difficult to read. Reading caps is annoying.
Format the column as text, if the leading zero is important to
you then it is an identification not a number. The default
alignment for text is left aligned which is also better for
most identification "numbers".
Credit card numbers are 16 digits, are identification and
can not be entered as numbers, ever, because Excel only
retains 15 si...alphabetize within a cell
if i have a list of letters in a cell, is it possible to alphabetize
example: ADCB --> ABCD
On Thu, 14 Feb 2008 12:31:05 -0800 (PST), firstname.lastname@example.org wrote:
>if i have a list of letters in a cell, is it possible to alphabetize
>example: ADCB --> ABCD
If your cells are contiguous and in a single column, here is a method that will
sort each cell and write the result into the cell in the adjacent column. It
can be easily modified for different situations.
To enter this Sub, <alt><F11> opens the VB Editor.
Ensure your project is highlighte...Can you put white space outside a textbox?
When I put pictures in my publisher file, sometimes I want captions
for the pictures. So I make a tiny textbox that I put under the
picture, and type in a caption into that textbox. The problem is that
I can make the picture have some space to left and right of it so that
text doesn't crowd into the picture, but I can't do that with the
textbox containing the caption. Is there any way to prevent outside
text from crowding the borders of a textbox?
You can move that textbox wherever you need. You don't need to leave space
inside when you can steer clear of the textbox itself.
...Add Path to Title Bar
How can I add path and file name to title bar of Excel
2002 workbook? Please let me know. Thanks in advance.
Take a look at:
Application.Caption = ThisWorkbook.Path & "\" & ThisWorkbook.Name
Activewindow.Caption = ""
Jack Mills wrote:
> How can I add path and file name to title bar of Excel
> 2002 workbook? Please let me know. Thanks in advance.
John, I'm new enough to Excel 2002 that I haven't any idea
where to start adding your suggested information to all of
my workbooks. ...Save record order in main table
I have a form which displays four field from a table. On the form I have 4
sort buttons which sorts the form based on the field selected. My table also
has a field for a sequence number. Based on the sort order selected I would
like the sequence number field for each record in the table to correspond to
the record number shown on the form. In other words, based on the sort the
first record shown on the form would get a sequence number of 1 in the table,
the second record shown would get a 2, etc.
Is this possible and if so could someone help with the code.
Your help woul...Where to put SQL statements in VC++ Application
I am wondering if putting all my SQL statements in the string table is
a good idea. Is there a better place to store these statements?? Thanks
in advance for any responses.
Inline in the code, they arnt particually helpful to put in the string
- Mark Randall
"Those people that think they know everything are a great annoyance to those
of us who do"
<email@example.com> wrote in message
>I am wondering if putting all my SQL statements in..."Purchase Order Processing setup information is missing or damaged" Error
I tried to Open the "Payment Document Setup" form or the "Payment
Document User Preference" form from the "Setup" module of
"Purchasing" then an error message "Payment Document Management Setup
is missing or damaged" gets displayed.
when I tried to Open the "Receivings Transaction Entry" form from the
"Transactions" module then an error message ""Purchase Order
Processing setup information is missing or damaged" gets displayed.
Go to Setup>Payment Document Setup, uncheck and then re-check ...Put app and icon in task bar?
I have an MFC application that I want to be able to
put in the task bar as a small icon and have it pop
up the dialog when selected from the task bar.
This app is intended to be run from the start up menu
and be minimized in the task bar along with all the other
Pointers on how to please...
By default app goes on the task bar. Do you mean system tray (that by
default appears on the bottom right of the screen)?
Ajay Kalra [MVP - VC++]
"ShipHead" <GoAway@SpamBoy.com> wrote in message
> I...outlook ka-put
After I installed the service pack updates for Microsoft
XP, my Outlook has been uable to send or receive any
email. I have gotten a few error messages: "unable to
connect to network," "server found but did not respond."
etc. What the heck do I do?
...Search Open Order receipts
My customer requires customers to put a deposit on Orders. They receive
these deposits on the Sales Transaction Entry window in the Amount Received
field. This works fine but there is not an easy way (that I can find) to
search for these receipts (by amount, by date, by customer name). Besides I
only want to search receipts that are on open orders (orders not yet
converted to invoices).
Any ideas on how to accomplish the above?
Microsoft GP/SBF Specialist
You can search the Receipts th...Title Column
Hi all. simple question.... how would i go about making column A
title column so when i move along, say to column z i can still see th
titles in column A. :confused
jhomer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2397
View this thread: http://www.excelforum.com/showthread.php?threadid=37596
Select column B
Does that help?
Ron Coderre's Profile: htt...Where to put error handler code for "No current record" error?
to brighten the essence of my current problem I woud like to describe the
situation from scratch.
I use Acess 2007.
I have two tables 'tblOrders' and 'tblOrderDetails' linked as ODBC tables
from MS SQL 2000 Server. Both tables have primary keys:
'tblOrders' has 'orderId' primary key and 'tblOrderDetails' has a pair
'orderId' and 'itemId' as primary key. On server there is also a foreign key
constraint defined on key 'orderId' between both tables.
In access I have a main form 'frmOrders' bounded to 'tblOr...Graph reverse order changes series order but not legend order
If I change the order of a graph in the axis properties the order o
the series is reversed as well as the order of the data, but not th
order of the legend. Is there any way to reverse the order of the grap
and keep the series order synchronized with the legend order beside
rebuilding the data set backwards?
Message posted from http://www.ExcelForum.com
...I can't read titles
As soon as I installed Office:Mac Home and Student on my Apple I noticed that when on Safari all of the Titles/Headings were not readable. It's as if all the letters were placed right on top of each other. Please, can anyone help
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 1/23/08 3:36 PM, in article firstname.lastname@example.orgR9absDaxw,
"Jaclyn_H@officeformac.com" <...GRID with title and records
Could you please advise me of what kind of grid should I use to have titles
and records below.
I need to have a "view"/grid where I have on product as title and below the
suppliers for that product.
The thing is that I must have to have access to the records in order to
select one of the suppliers for product.
...How can I reverse the order of a column of numbers . . . #2
I want to turn a long column of numbers upsidedown so that the last entries
become the first vice versa.
You could do this with a helper column.
In a blank column next to the column you want to reverse:
Type 1 in the first cell, 2 in the second cell.
Then, select both cells and double-click on the Fill Handle to fill a series
of increasing numbers. Then, Sort Desceding by the new column.
When you are done, you can delete the helper column.
> I want to turn a long column of numbers upsidedown so that the last entries
> become the first vice versa.
...How do I put it back?
In Microsoft money 2003. Used to: When I put on my paycheck I would have a
window pop up with seperate catagories, "taxes", "healthcare", ect. there
were four of them. Now when I put them in I just get one "spit catagories"
window. I don't know how I changed it or how to change it back. I can't
even find any support that can/ will help me. If anyone knows Please let me
know. I will be greatly indeted to you. thank You.
"Derek" <Derek@discussions.microsoft.com> wrote in message
news:D9D38C7E-D837-4376-99D3-79C760EC4F85@mic...how to put constraints in excel
how to put constraints in excel
You need to be more specific in your question. Perhaps Data
Validation, on the Data menu, will do what you want. This will
allow users to enter only values in a range of numbers in a cell.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"structures" <email@example.com> wrote in
> how to put constraints in excel
...print multiple emails in specific order
In Outlook 2003, is it possible to print multiple emails in a
specified order as one consecutive item? That is, each email should
NOT be on a separate page.
E. L. Brother
...Put % in ( )
Is it possible to format a cell to stay like it: ( -10% )?
With this format (0%), the excel shows this - (10%)
Thanks a lot!!!
Try this Custom Number Format:
Select the cell(s) to be impacted
From the Excel Main Menu:
Those settings will display:
10% as (10%)
-10% as (-10%)
0% as (0%)
Is that something you can work with?
Microsoft MVP (Excel)
(XL2003, Win XP)
<firstname.lastname@example.org> wrote in message
news:4188b0ad-a272-455...How do put a Logo on the Receipt
Is there anyway I acn put a logo on my Receipt.
If I remember I simply copied out the file pos_symbol.gif in C:\Program
Files\Microsoft Retail Management System\Store Operations\HTML\Images to get
the size, and then renamed that file, uploaded one of my own.
> Is there anyway I acn put a logo on my Receipt.
that did not worked, can you be more detailed about it
> If I remember I simply copied out the file pos_symbol.gif in C:\Program
> Files\Microsoft Retail Management System\Store Operations\HTML\Images to get
> the ...Title page header
Operating System: Mac OS X 10.5 (Leopard)
How do I change the header on only the title page of a document?
> How do I change the header on only the title page of a document?
You could make a section break after your title page. This should enable
you to use different headers after the first page.
--- Office:Mac MVP http://www.cortig.net/wordpress/ ---
http://www.mvps.org - http://mvp.support.microsoft.com
MVPs are not MS employees - Les MVP ne travaillen...putting photos into autoshapes
I publish a newsletter for a charity and would like to improve and vary the
presentation. How do I make a standard photo go into an oval or other
autoshape? I have done it once but can't recreate it. I have windows XP,
publisher 03 and works suite 04. My photos are usually JPEG.
Select the shape, fill, fill effects, picture tab.
Mary Sauer MSFT MVP
<christiredlady(removethis)@email@example.com> wrote in message
news:069B7725-3...Force Close Manfuacturing Order(s)
I've got a handful of Manufacturing Orders that are complete and need to be
closed. However, many of the items still have a quantity shortage on the
picklist and therefore cannot be closed.
The reason for this is that the client has asked for these to be closed as
they are old and everything has been processed. So I'd like to just force it
closed without having to fix the shortages (as they have already been
The message I am getting when I try to close is "You can't close this
manufacturing order because there is a quantity shortage for at least one
...Inserting More Than 1 Chart Title
Can anyone tell me if it is possible to insert more than
1 chart title, and if so how.
To add more text to a chart, select the chart, and type the text.
As you type, you'll see the text in the formula bar.
When you press the Enter key, a textbox will appear in the chart.
You can drag this to a new location in the chart, and format it with the
buttons on the formatting toolbar.
> Can anyone tell me if it is possible to insert more than
> 1 chart title, and if so how.
Excel FAQ, Tips & Book List