change numbers to date
how to change a column of numbers to a date like
2411 to 24/11/05
3011 to 30/11/05
The formula is -
in a cell that has been formatted to dd/mm/yyyy
"abe" <firstname.lastname@example.org> wrote in message
> how to change a column of numbers to a date like
> 2411 to 24/11/05
> 3011 to 30/11/05
Then select the style you want
Hope that helps :)
-- ...How to get the digit number of a LONGLONG data?
How to get the digit number of a LONGLONG data?
for example:LONGLONG aaa=123; then the digit number is 3;
LONGLONG aaa=5678; then the digit number is 4;
Another way is:
int digits = 0;
LONGLONG number = aaa;
while (number > 0)
number /= 10;
>How to get the digit number of a LONGLONG data?
>for example:LONGLONG aaa=123; then the digit number is 3;
> LONGLONG aaa=5678; then the digit number is
As long as the number isn't negative.
"Geo" <ckarakiro@hotm...How can I extend maximum number of records when opening sylk file?
When opening a .slk file in Excel 2002 you can only see the first 32,767
I have a file that is larger than this , and therefore I cannot see all of
I know that you can extend the maximum number of records when opening a text
file - I just need to know how to do it.
Can anybody help me please?
Opening a text file and a SYLK file are two different operations "under the
hood". If 32,767 is the limit, there's probably not much you can do about it.
Do you have control over the workbook from which the SLK file was produced? If
so, can you split it into two ...HDD Serial Number.
I want to find out the HDD Serial Number in my C++ Code.
There seems to be a way using the WMI. But I donot (cannot) use it.
I want to know if there is some C++, C or assembly code that can help me do
Any help/suggestions would be very helpful and highly appreciated.
You can do this with GetVolumeInformation()
"Anwar Khan" wrote:
> I want to find out the HDD Serial Number in my C++ Code.
> There seems to be a way using the WMI. But I donot (cannot) use it.
> I want to know if there is some C++, C or assembly code that can help me do
&g...Auto Number for Invoice
It's probably here somewhere - just can't find it.
Need to automatically add incremental number as various users ope
common Excel Template (stored in common template directory) so as eac
person opens a new file from the template the next number i
Have tried adapting standard Invoice that comes with Excel but reall
is too complicated - only need to change the one cell each time.
Using Excel 2000 with win98SE
If someone can point me in the right direction... thanks..
~~ Message posted from http://www.ExcelTip.com
~~View and po...Custom Number Format #9
I'm trying to set a cell format to either $ or % determined by the value
input by the selection of one of two lists dependent on a $ or % selection
criteria in another cell. If the value input is within the range of -1 to
1, I need it to display in a percentage format. If it is less than -1 or
greater than 1, it needs to display as a currency format (or comma w/ 2
I prefer using data validation lists on this sheet instead of other controls
due to their larger size. The version is Excel 2000. Any assistance is
You could use a helper cell to show the f...Preventing rounding numbers to nearest dollar
When entering currency data into a form Access rounds the number up or down
to the nearest dollar. The fields for the form and table are formatted for
currency, 2 decimal places, field size is long integer. I am not using any
queries. How do I prevent rounding numbers to nearest dollar?
MS Access 2003
> When entering currency data into a form Access rounds the number up or
> to the nearest dollar. The fields for the form and table are formatted for
> currency, 2 decimal places, field size is long integer.
Since Long data types are "whole num...Page numbers when I have 2 section breaks in 1 page
What do I do with my page numbers when I have 2 section breaks in 1 page.
-(Page) at (SectionPages)-
Right now it says 1 to 1 beacause of the section breaks. I would like it to
be 1 to 5 ex.
My problem is that I have a title which is framed in 2 section breaks. Im
doing this because I write in columns and i dont want the title to be in
columns-format. The problem is so, that it counts the title of an independent
section and confuse the page number. How do I get it to count for a single
Instead of using section breaks around the title, I would pro...page number in each section
I have several section and the footer shows page # of #. In each section, I
want it to start at 1 of number of pages in the section. I figured out how
to change the first number so it is correct-- but I can not figure out how to
change the total number of pages in the document to the total number of pages
in the section.
How do you change it so is show the total number of pages in the section?
Use the SectionPages field instead of NumPages.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mv...Worksheet Borders/Labels (name???) both coming up as numbers
I have probably an obvious question, but nonetheless, here it goes....One of
our users has an excel worksheet where it shows up as A, B, C,, etc. along
the top and 1, 2, 3, etc. along the left side. When she sends it to someone
else in our office, it is coming up as 1, 2, 3 along the top and sides. Is
this a setting that the second user has? I haven't been able to find a
solution online for it. Help!
Check R1C1 reference style to see numbered columns.
Uncheck it to see lettered columns.
Kerri Schultz wrote:
> I have probably an o...How do I locate my product key number
I did not receive a confirmation e-mail with my product key number when I
downloaded the 60-day free trial of Microsoft Office 2007. How do I locate
You need that email.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Pat77" <Pat77@discussions.microsoft.com> wrote in message
>I did not receive a confirmation e-mail with my product key number when I
> downloaded the 60-day free trial of Microsoft Office 2007. How do I
> l...count number of "D"
I am new to excel .. here is my requirements.
449 78 d
449 69 m d
458 260 m
469 28 m
472 39 m
479 51 d
484 59 m d
i need to count number of "d" present in the 4 th column and number of
m present in the 3 column.. its a very big table and i need to
how to do it?
thanks in advance !!
jayender.vs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28640
View ...Cannot generate PO Number
I am facing a problem with automatic generate PO Number, the application is
working on this senario:
SELECT ISNULL(MAX(CAST(RIGHT(PONumber, 7) AS INT)), 0) + 1 AS NextPONumber
FROM PurchaseOrder WHERE ISNUMERIC(PONumber) <> 0
my max is '9999999', so it is generate a new one with PONumber = '10000000'
then every time it is cannot generate a next one cause of '0000000'
can anyone help me on this ?
...Seperating Numbers and Text
I need to seperate the numbers and words in the same cell. Not all tex
and/or numbers are the same or are the same amount of characters.
is all in the same cell
22454 to be in one cell and
IN in another cell to the right
Message posted from http://www.ExcelForum.com
I assume that the original cell is text. If it is, then
you can look for the position of a blank, then separate the
two based on the blank location. If cell A1 has "22454 IN",
In cell A2: = Search(" ". A1)
In cell A3: = Left(A1,A2-1)
In cell A4: = Right(A1,Len(A1) -...Styles and Set Numbering Value problem
Running MS Office Pro 2007 with Windows XP Pro.
I have styles defined for numbered lists. These styles have simple
characteristics, like indent, space before, etc. - nothing special.
I want the numbered lists to appear throughout the document, with each
starting at the number 1. When I try to start a new list using the Set
Numbering Value dialog, I get a message saying "Changing the number format
for this list updates the style "NumList" and reapplies the style to each
paragraph. Do you want to continue?" If I select no, the starting number is
not chan...Convert Column Number to Column Letter
I have the last column of data. I want to use a range to say copy or define
something. So how do you convert the number LastCol to a letter to display
in a Range:
LastCol = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column
A web search for "convert column number to letter" turned up several hits,
one of which was:
look at the last 3 posts in that discussion. Two ways to get the job done.
Personally, since you've gone the route you have at this point, I'd probably
go with the solution in the last ...Divide number and add remainder in another cell
Can someone help me? I made a work distribution spreadsheet and I can not get
it to divide evenly. What I am trying to do is divide the total number of
claims by the number of employees and distribute the result to each employee.
There are conditions also. For example one employee gets the max number of 50;
Here is my formula;
column E =# of hours working for each employee,
I19 = total number of claims.
If the total number of claims is 1500 and there are 5 people working it
returns 50 to the E18 employee and 363 to the rest, but t...Deleting all even numbered rows?? Help
I have some data up to row 2200. Unfortunately, the data was capture
with a glitch, to where all even numbered rows (2, 4, 6,.....2200
contain bogus data.
I want to delete all even numbered rows in the spreadsheet, and hav
the 1100 odd numbered rows shift up, so I have only 1100 rows of th
real data on the spreadsheet
Yel268's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1570
View this thread: http://www.excelforum.com/showthread.php?threadid=27234
- in a helper c...Inventory Adjustment with Lot Number
How do you remove a quantity from inventory for an item that uses lot
numbers. Currently the Stock Status reports shows a quantity of 167 but it
should say zero. I tried doing an inventory adjustment and I had to create a
new lot number. It posted through ok, but when I check the Stock Status
report, the item is still there showing 167. I'm stumped.
> How do you remove a quantity from inventory for an item that uses lot
> numbers. Currently the Stock Status reports shows a quantity of 167 but it
> should say zero. I tried doing an invent...Returning last number(time) in a row of cells
Need some help with this one please;
Row A4 thru J4
A4 B4 C4 D4 E4 F4 G4 H4 I4 J4
12:00 15:00 16:00
I need to return to cell K4 the last number in the above row.
I do not know what formula to use. Any help would be greatly appreciated.
There are several ways to achieve that, - here are two:
> Need some help with this one please;
> Row A4 thru J4
> A4 B4 C4 D4 E4 F4 G4 H4 I4 J4
> 12:00 15:00 16:00
> ...Convert Numbers to Text with a Source Code list
I have a column of data with numbers relating to specific industries. Each
row corresponds to an individual and their affiliated industries. Some cells
contain 1 number and some contain several (separated by commas). I would like
to break this column apart into each individual industry for separate
columns. The corresponding person would have an x in the column that refers
to the industry they relate to. I have a separate sheet for what each code
(number) means. HELP!
Have you checked out Data -> Text to Columns... To split out your numbers?
...Write a sum formula to determine the total of all the numbers bel
how can i do the the work to havee to do
The formula to sum all the numbers is =SUM(A1:IV65536)
"cristian" <email@example.com> wrote in message
> how can i do the the work to havee to do
One way to get the work done is provide more detail in the body of your
Your subject line reads only............
"Write a sum formula to determine the total of all the numbers bel"
The formula to sum all numbers in column A below 46 is
=SUMIF(A1:A1...numbers in text box
I am recieve data from a scale in text box. It has number and other carater.
How I could take only number in text box. I am work with 2008.
thanks for your help
"Roberto Londono" <RobertoLondono@discussions.microsoft.com> wrote in
>I am recieve data from a scale in text box. It has number and other
> How I could take only number in text box. I am work with 2008.
> thanks for your help
It depends on how you receive your data, but I did this for a similar
situation. I...Change the number of charaters in a cell by adding a zero
I need to change the number of charaters in a cell by adding a zero to the beginning. Example 12345678 to 012345678. Tried changing formats, number to text, and custom with nine zeros.
Both changing the number to text, and the nine 0 custom format should work.
If you changed the number format to text after you had entered the number, then the preceding zero was already dropped before the format change. You need to change the number format to text before entering the number.
If you change the number format to the nine zero custom after you had already changed to cell to tex...Number format
I have a number 000702 but in the cell only 702 appears. How do I format to
see the preceeding zeros
"afdmello" <firstname.lastname@example.org> wrote in message
> I have a number 000702 but in the cell only 702 appears. How do I format
> to see the preceeding zeros
What "cell"? IE doesn't HAVE "cells".....
Did you even notice the subject of this newsgroup?
"afdmello" <email@example.com> wrote in message