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 & Time Excel by Suleman[_2_]
=Now() working Butt Time Is Not Working Like As Clock Mean As after 60 Second Must Be change the word of min Like if Now 23:52 after 60 second it will become...
May 1st, 2008 12:01 AM
by Gord Dibben Go to last post
1 260
Date 1904 - How to convert to Date 1900? by Alex St-Pierre
Hi! Does anyone know how to convert an excel file where the date are in function of 1-1-1904 to an excel where the date are based on 1-1-1900? I know I can do...
May 4th, 2004 01:25 AM
by Dave Peterson Go to last post
1 557
Date and Time display by Chiropter
In older Excels it was possible to edit or write a new format to express date and time in a desired way. Now in Excell 2000 there is no such function offered...
February 23rd, 2007 07:54 PM
by Paul B Go to last post
3 122
Date and Time Picker by anthony
I have re-installed excel, however I have now lost function such as the Date and time picker. How do I reisatll these?
May 19th, 2004 01:43 PM
by anthony Go to last post
0 286
date and time picker by amthony
I have re-i nstalled excel, howver I have know lost the common contril function, and the date and time picker. How do I reinstall them? Any help would be...
May 27th, 2004 06:49 AM
by Raghu Prakash Go to last post
1 242
Date Changes by DA
I have a share file that shoes the dates in the year 2005. When I copy the file, the dates change to 2001. What is causing the change?
September 20th, 2005 05:21 PM
by Gord Dibben Go to last post
2 156
Date Conditional Format by JK
I need a formula or code to apply into a cell that will flag a user if a record is greater than 90 days from today. I have tried variations of IF statements...
September 25th, 2006 03:17 PM
by Stefi Go to last post
3 172
date default format/acess to excel conversion by Diann
When creating a .csv file from an Access table, the dates in the subsequent Excel spreadsheet are in the date+time (5/31/02 00:00) format even though the field...
February 18th, 2004 05:03 PM
by Go to last post
1 694
Date Drop-down list by azlan
Hi, May i know how i can add drop-down of calender in a excel cell so i can quickly just click to pick up the date instead of typing on my keyboard? Thank...
July 4th, 2007 05:51 AM
by TechGuy[_2_] Go to last post
2 148
Date Format by Loris
In Excel 2003, when I try formatting a number as a date using the CTRL-SHFT-# shortcut, it displays as dd-mmm-yy, e.g., 10-Oct-06. I thought it might be...
October 10th, 2006 05:46 PM
by Dave Peterson Go to last post
1 289
date format by Bob
How do I change the date format from US to UK in Office 2000, I am using Windows ME. I have changed everything else on the computer to UK format, but excel...
November 5th, 2004 10:48 PM
by Dave Peterson Go to last post
1 142
date format by rita
All of a sudden my excel spreadsheet is not regognising dates (eg 24/2/04)as a date but will recognise 2/1/04 (2nd Jan 2004)(english) as 1 Feb 2004 (american)....
February 26th, 2004 02:11 PM
by Go to last post
4 152
date format and day of week by James
I downloaded a file into excel that has a column of dates (ex., 10/20/2007). I then formatted this column to the same date format. My goal is to have a...
July 1st, 2008 08:44 AM
by Bob Phillips[_2_] Go to last post
1 281
Date format in Excel by Nivesh
Hi All When entering a time in a cell, i'd like to validate the date is in PST (Pacific Standard Time). That means if I'm in some other time zone (like GMT)...
August 4th, 2004 02:47 PM
by Nivesh Go to last post
0 100
Date formats by Nephs
When opening a csv sheet containg dates via a macro, all dates up to the 12th change to american format so 01/09/2004 (1st september 2004) becomes 09/01/2004...
March 12th, 2004 03:40 AM
by Dave Peterson Go to last post
1 112
Date formats by Andy M
When I enter dates into a cell (e.g. 1/3/03), and the cell formatted to show 14 MAR 2003, the date is shwon as 3 Jan 2003, not 1st March 2003. I presume there...
November 4th, 2003 03:53 AM
by Andy M Go to last post
2 453
Date formatting by Kris
I've downloaded data from another site. Downloading into excel was an option, which I did. The data contains columns of dates. I've formatted the data to...
June 2nd, 2009 11:21 PM
by Gord Dibben Go to last post
1 133
date formatting error by TMF in MN
My spreadsheet has several columns with dates entered. Just today the data is reading 38986 instead of 09/26/2006. I checked the formatting and it is set up...
September 29th, 2006 05:02 PM
by Dave Peterson Go to last post
1 161
Date in Pivot table question by Tom Bradstreet
I am using a pivot table to look at summary data for our cell phone usage. I would like to make one big spreadsheet and view the entire year. The call...
January 11th, 2007 05:37 PM
by Tom Bradstreet Go to last post
2 171
Date incorrect in excel by because
For some reason that has just started....When I type a date into Excel the year comes up wrong . For example when I type in March 1....and press enter....it...
January 11th, 2006 01:18 PM
by because Go to last post
2 77
Post New Thread


Display Options
Showing threads 961 to 980 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 05:05 AM.


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