A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Setting up and Configuration Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
date not correct in cell by [email protected]
Hi I formatted cell A1 to date cell till sofar the date 01-11-06 appears as requested in that cell When I copy A1 to B1 (B1=A1) it gives also the correct...
November 1st, 2006 03:09 PM
by [email protected] Go to last post
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,...
July 7th, 2008 04:39 PM
by Vladimir Go to last post
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...
September 28th, 2007 12:42 PM
by Niek Otten Go to last post
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...
January 6th, 2004 11:05 AM
by Norman Harker Go to last post
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?
December 17th, 2008 07:03 PM
by Gord Dibben Go to last post
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...
June 14th, 2006 10:13 PM
by Dave Peterson Go to last post
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 Go to last post
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 Go to last post
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...
November 30th, 2007 03:53 PM
by Roger Govier[_3_] Go to last post
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...
June 3rd, 2004 01:45 PM
by David McRitchie Go to last post
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 Go to last post
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...
September 24th, 2005 12:56 AM
by David McRitchie Go to last post
1 136
Days of sales in inventory template by jr
I am looking for a template to calculate days of sales in inventory
March 14th, 2005 04:11 PM
by jr Go to last post
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 Go to last post
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...
September 30th, 2003 01:58 AM
by Dave Peterson Go to last post
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. ...
November 18th, 2003 03:09 AM
by Dave Peterson Go to last post
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...
January 23rd, 2004 04:15 PM
by Norman Harker Go to last post
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...
May 8th, 2008 11:59 PM
by Dave Peterson Go to last post
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...
March 19th, 2004 06:16 PM
by Gord Dibben Go to last post
1 446
decrease the viewing area / not scroll billions of rows/columns by Kclueless
When the worksheet was created, the user scrolled over the row/column to format (highlighted all of row 5, for example). I want to make an 'end' to the...
April 30th, 2009 08:40 PM
by Gord Dibben Go to last post
3 161
Post New Thread


Display Options
Showing threads 981 to 1000 of 5209
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.