Can I change the calendar year beginning date?
Our fiscal year runs July 1 thru June 30 of each year. I need to track
attendance, gas cards, etc for monthly reports. I have a HUGE table with a
gazillion queries and reports for each one. I need one report to reflect
quarterly output for our fiscal year as stated above. Can I make this report
Create a query to use as the source for your report.
In query design, type this into the Field row:
FinYear: DateAdd("m", -6, [InvoiceDate])
replacing InvoiceDate with the name of your date field.
This yields 2007 for all dates in the 2007/2008 financial year...Date Formatting when Concantenating
I have a simple question. I have a cell that has date that looks lik
When I use the concantenate feature my date looks like this:
I tried to format the call every which way - but I cannot get it t
look the original.
Feeling really silly for even asking.. thanks all for your help
Message posted from http://www.ExcelForum.com
="Today is "&TEXT(TODAY(),"mm/dd/yyyy hh:mm")
Norman Harker MVP (Excel)
"bleu808 >" <<bleu808.189yij...Show a date 30 days out
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].
Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
I did =[Sold date]+30 and it did not work
how about dateadd:
dateadd("d", 30, [Sold Date])
"KAnoe" <KAnoe@discussions.microsoft.com> wrote in message
>I have a feild that I would like to show what the date would be in 30 days
> for a feild with a date in it [Sold Date].
...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...Default font for pasted text in text boxes
I am having a problem with text boxes in Excel 2007.
When I copy text (in Arial font) and paste it in the same text box, it
appears as Calibri. I would like it to appear as Arial, just as it was when
I copied it.
I followed the directions for setting default font in new workbooks to
Arial, and I have this problem even in text boxes within new workbooks. I do
not have the problem outside of text boxes within new workbooks.
I also followed the directions for setting default text box style, and new
text boxes have Arial as their default font, as they should. However, when I ...Uncheck "always use the selected program to open this kind of file" by default
> If I right click on a file there is usually the option to"Open with..".
> Selecting this option list possible programs with which to open the
> application and, below this, there is a check box labelled "always use
> selected program to open this kind of file". The check box is always
> checked, so clicking on OK permanently associates the selected program
> the file type in question.
> However, I usually use this option to op...Line Chart with dates in 5 day working week only
Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.
When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!
Hope this makes sense.
Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn...Report Format
Env: CRM 3, VS 2003, remote connect to CRM server.
I've created a QUOTE in VS2003 and when viewed using PREVIEW from within the
VS environment it produces a beautiful QUOTE (at least in my opinion). When
printed, again from the VS environment, it is perfect. When I upload the RDL
file to the CRM server, create an new REPORT using this RDL then produce a
REPORT, the formatting is all over the place. When I inspect the source (in
VS) there are no fields that extend past the defined size. It appers that the
CRM report engine randomly adds CRLFs all thru the report ... ???
...formatting problem #5
How can I get Excel to change to colour of an entire row when I enter
data in a specific cell?
If I have data in the cell range A1...G1 and then I enter data in H1
I want Excel to change the colour of the entire row to indicate that
the task is complete for that row, but still leave the data readable
Thanks in advance
srv5uk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25006
View this thread: http://www.excelforum.com/showthread.php?threadid=385314
It sounds lik...how to format a column to corespond with another
I want to make column "E" read "N/A" when column "B" reads "0". How do i do it?
Put this in E1:
and copy down.
Hope this helps.
On Dec 3, 9:09=A0pm, JeremyC. <Jere...@discussions.microsoft.com> wrote:
> I want to make column "E" read "N/A" when column "B" reads "0". How do i =
> I want to make column "E" read "N/A" when column "B" rea...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Conferting File format
One of my users stored 250 photos on CD in a pdf format. The person that will
work with them wants them in a raw format. Is there any way to convert the
entire disk at one time to a raw format, rather than opening each file and
saving in the new format? Thank you.
vsp deborah <email@example.com> was very recently
heard to utter:
> One of my users stored 250 photos on CD in a pdf format. The person
> that will work with them wants them in a raw format. Is there any way
> to convert the entire disk at one time to a raw format, rather than
> opening each f...Help with conditional formatting with 2000
Any help would be greatly appreciated.
I am trying to group data together into increments of 10% of th
numbers and then chart them based on these groups. For example, I hav
300 data points that vary from 20 to 500 in value. I want them t
appear in a chart based on the number of values that fall in the lowes
10% of numbers (ie. 20-40) then the next 10% (ie. 40-60) etc. up to th
top 10% of numbers, but I do not want to manually determine what thes
ranges are. I want to see a distribution of how many numbers fal
within each 10% of values.
I am not sure if this makes sense, please let me know...date/time formatting
I download a csv report from a web based program. Everything works great
but the date comes through as "Jul 21 2009 1:51pm". I do not need the time
in my report. I have tried reformatting the cells, tried to copy to a new
file with the cells already formatted to "7/21/09", opening the cell format
using the F2 key and deleting the time (time will still not be formatted
correctly). The only way I get get just the time is to retype every cell.
What am I doing wrong?
I am using Excel 2002 SP3
When data is downloaded from the web, a lot of "other&quo...Too many different cell formats #6
I am running into the error message:
Too many different cell formats
Is there a solution to lowering the number of formats I
am using? Just trying to change them to make some
consistent gives me the same error message.
I tried running the search on the forums on my topic but
they have been disabled for a Microsoft upgrade.
One idea -
Rob Bovey's excellent Utilities add-in will list all the formats in use in
your workbook, allowing you to manually delete what isn't being used.
You can also see the source code for ...format cell #4
In Access, I can set up a field that "forces" the user to enter info - a
date, for example - in a certain way, such as 25 Jan 05 or enter time as
12:15 AM. Is there a way that I can "force" this in excel?
Without invoking something more technical, you can select the cell(s) and go
to Data>Validation and choose what type of entry be allowed in the field.
Format the cell in the manner you wish to have the date or time expressed.
> In Access, I can set up a field that "forces" the user to enter in...Setting the default font and font size for Excel comments
Do you know how to set the default font and font size in
Excel for the cell 'Comments'?
I have looked in Options as well as in the registry to see
if I can change the default from Tahoma (size 8) to
another (i.e. Arial size 12).
Your help would really be appreciated.
Clint - UK
I presently have an XY line chart showing asset price over time. Pretty
X Axis - Time Scale
Y Axis - Asset Price
I would now like to add an additoinal series showing the volume of
assets traded, ideally this would be as a bar chart sitting
"underneath" the asset price on the chart. They would share the same X
I have added another series, but this simply displays the volume traded
as another line, and even when this is set to a secondary axis the
scaling makes this unworkable. i have adjusted the scales of both,
still this does not make it workable, i want the series...unicode format files for Outlook 2002
I use Outlook 2002. I would like to use Unicode files (for larger size). I
see references to using it with Outlook 2003, but none for 2002. can
unicode files be used with Outlook 2002? If so, how?
OL 2003 & 2007 only
"Huck Rorick" <firstname.lastname@example.org> wrote in message
>I use Outlook 2002. I would like to use Unicode files (for larger size).
>I see references to using it with Outlook 2003, but none for 2002. can
>unicode files be used with Outlook 2002? If so, how?
> than...Formatting cells and getting pound signs
I am using Excel 2003 with all updates as of 4/28/04 and trying to format a cell using the custom category and choosing the #,##0.00 type.
I am trying to add the $ symbol at the beginning of the type and add text at the end of the type to look like this $#,##0.00 "text".
When I do this however it shows up in my cell on my worksheet as ##########. It does know what the value is and shows as I would expect it to when I place mouse over cell in a balloon
If I use only the $ symbol befor the type it shows fine. If I use only the "text" after the type is shows fine. Using the...Does anyone have a format or template for a Education Cover Letter
Does anyone have a format or template for a Education Cover Letter?
To Whom It May Concern:
Enclosed please find an education.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"eb" <email@example.com> wrote in message
> Does anyone have a format or template for a Education Cover Letter?
"Suzanne S. Barnhill" <firstname.lastname@example.org> wrote in message
news:O3aNFsq2KHA.5212@TK2MSFTNGP04.phx.g...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...time formats #3
I have an Excel sheet with a long list of times spent on various projects.
The times should all be in minutes and seconds. The first time reads 2:29
and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it
reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is
right, for 40 seconds. But in the formula bar, I see 12:40:00 AM
I want numbers, but apparently I am looking at times.
I tried changing the format. When I check the format for 2:29, it comes up
Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but
that changes the displa...Conditional Formatting on cells beginning with a hyphen
Is it possible to do conditional formatting on cells beginning with a
1. Place the cursor in A1 cell and select the Range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and paste the below formula
4. Click Format Button>Font>Color select your desired font & Background
Color pattern and then give ok
Change the cell reference of A1 to your desired cell, if required.
But keep in mind that when applying the conditional formatting the Active
cell should be in the ce...