|
|
|
|
2 |
185 |
|
|
Date problem YYYYMMDD by
Hilco van Olst
We have a problem with excel 2007 NL ;
a date format used as YYYYMMDD is treated as a date format as YYYYDDMM.
When i import a file with a date : 20080405,...
|
|
1 |
235 |
|
|
Date problems by
Gerry[_4_]
I am using dates with the format .... yyyy/mm/dd in a Genealogy worksheet.
When I input dates in the 1900 range I get all sorts of problems ....
showing as...
|
|
1 |
99 |
|
|
Date Problems by
Andrea Jones
I'm using Excel 2000 SP3 on an NT4 machine with SP6. I've
set the Windows regional settings to English(UK) and the
Microsoft Office Language Settings to...
|
|
3 |
398 |
|
|
Date set up by
Danny
Can I just punch-in the numbers for the month, day & year, without the
slashes and Excel shall put the date (in the cell) in the format that I want?
|
|
1 |
164 |
|
|
date sorting troubles by
Nevin
I have a simple spreadsheet with the date column formatted as (June 13, 2006)
and I am having trouble with the sorting. I have tried various tips...
|
|
5 |
297 |
|
|
Date Time Picker in 2003 by
Opalus
I have added a new computer with Office Professional 2003. An existing Excel spreadsheet using MS Date and Time Picker V6.0 does not work on the new machine. ...
|
July 20th, 2004 01:36 PM
by Opalus
|
1 |
199 |
|
|
Date-error Format by
Mia
I´m trying to do a sheet make o new date format. The new format should be
yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001.
The formula...
|
July 1st, 2008 07:10 AM
by Mia
|
7 |
228 |
|
|
date/time by
Help with Excel date/time formats
Is there a way to set up a cell with a specific date format such as
11/30/2007 in which all the person would havee to type is 11302007 and the
rest...
|
|
1 |
128 |
|
|
Dates by
Emma
I am importing data on which includes hundreds of dates in the format 09/11/76. Problem is that I need to sort them by month (ignoring day and year). Is...
|
|
1 |
162 |
|
|
dates and times help by
Crabtree
How do I type dates and times in excel without using "/" and ":"? I would
like to be able to type 08152004 and have it automatically change to
08/15/2004. I...
|
August 15th, 2004 09:47 PM
by Paul B
|
1 |
238 |
|
|
David McRitchie (subject header) by
Walter Copeland
I do so appreciate your advice and will definitely check your site for
needed information. However, I was unaware of the rules of engagement
pertaining to this...
|
|
1 |
136 |
|
|
|
March 14th, 2005 04:11 PM
by jr
|
0 |
107 |
|
|
DDE Connections by
Clamott
Has anyone had any experience with the DDE connection
function in Excel? I am currently having a problem with
the mail merge project and it's saying that it...
|
August 19th, 2004 05:06 AM
by larbear
|
2 |
348 |
|
|
Deactivating the F1 key by
Azhar Moinuddin
I work extensively on Excel. While using the F2 edit key,
I accidently press the F1 key and suddenly the help starts
when it is not needed. This takes quite...
|
|
1 |
521 |
|
|
Debug error by
Paul W. Schu
After installing Excel 2000 on a Win95 machine. When 1st
opening Excel I get an error: Microsoft Visual Basic
Compile error:Cannot find project or library. ...
|
|
4 |
291 |
|
|
dec point ends up giving date by
jd
help!!
a user has an acer laptop. Wen he inputs 12.07 or similar in an unformatted
cell, the cell converts the input into date format rather than retain...
|
|
1 |
156 |
|
|
DEC2HEX with VBA in Excel 2007 by
Rishi
I have a program working with Excel 2003 with VBA that uses the DEC2HEX
function within the VB routine (not in the Excel sheet)
I have turned the Analysis...
|
|
5 |
300 |
|
|
Decimal Point Separator by
Mark
Setting: "Fixed decimal point 2"
Separatoir "."....prior to Excll 2003, I was able to
enter a whole number (25.00) by entering "25."....now
when I enter...
|
|
1 |
446 |
|
|
|
|
3 |
161 |