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...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...Is it possible to set a slide transition that mimics turning page
I've been asked for help in setting up a PPT presentation to have slide
transitions that mimic turning pages. I have seen this done using Keynote on
a Mac but the software being used for this presentation is PowerPoint.
Any ideas on if this is available or where I may find a download to add to
The setting I use to achieve that is:-
Animations tab / Transitions to This Slide group / Wipes / Strips Left-Up
If my comments have helped please hit Yes.
> I've been ask...1 Chart
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...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 ... ???
...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...how can i set up my pop and smtp account using proxy server in ou.
"Abhishek" <Abhishek@discussions.microsoft.com> wrote in message
You'll need instructions from your ISP.
Ben M. Schorr, OneNote-MVP
Stockholm Consulting Group/KSG
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
...Setting Outlook settings to new server
We are in the process of moving mailboxes to a new server. Is there a utility
or ad policy to automatically configure outlook to point to the new exchange
server? Instead of manually configuring the users outlook profile.
On Tue, 21 Nov 2006 11:15:01 -0800, Rich
>We are in the process of moving mailboxes to a new server. Is there a utility
>or ad policy to automatically configure outlook to point to the new exchange
>server? Instead of manually configuring the users outlook profile.
If you are moving the mailboxes in the same org vi...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 <firstname.lastname@example.org> 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...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 ...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" <email@example.com> wrote in message
> How to get only the year in the date form...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...Paper settings change for specific printer
I just installed access 2007 and my application uses reports to print labels.
Specifically a Dymo turbo 400 and 30252 address labels. when i was using
acess 2003 i specified to use a specific printer and everything was great.
and when i copied updated FrontEnds to my networked computers every thing
transfered and the labels printed fine however with 07 the "Specifc printer"
has a different page size.. i fixed all the reports on my master FE but the
changes didnt stay when i copied FE to other computers and im not sure where
to go. i installed all the printers from the s...Outlook 2007 - Exchange 2003
I just upgraded my desktop to Office 2007 - Removing the older Office2000.
Our Network is all 2003 Servers & Exchange. My Destop is XP SP3
In OL2007 I cannot see/find any of the exisitng public shared calendars that
I could see/access in OL2000. I can see them when I'm in Webmail and
desktops still running Office 2000 can see the public calendars.
Any help is appreciated.
Which navigation pane are you in? Press Ctrl+6 to see the folder list.
BTW, Did you keep the old Outlook 2000 profile? We recommend new profiles
when upgrading from older versions.
...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...how can I add a signature to my calendar appt requests?
See subject question
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"tnowak" <firstname.lastname@example.org> wrote in message
> See subject question
...Viewing shared 2003 outlook calendar in 2007 Outlook
Shared calendars with colleagues who have 2003. I can see the calendar but
not the info in the calendar. Nothing is provate marked from their side and
is able to be seen by other 2003 users.
is there a quick fix?
...Saving MY Calendar into "Publication-Calendar"
My problem is that I have to make a certain type of calendar in every month. It would save lots of time forme if I could find a way that I could save my "calendar setting" and also be able to apply the new month's settings. There is any way that I could save my "home-made" calendar into "Publications-Calendar" and call it up just like the other calendars? Thanks.
If you have repeating items you just use the Merge for those items every
"If you don't know where you are going,
any road will take you there!"
I do not understand ho...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" <email@example.com> 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...Remote access to another company's Outlook calendar?
I have one client on Exchange 2003 that wants to access the calendar of an
employee (consultant?) at another company running Exchange (version not
known yet). How can the remote company share this person's calendar with my
client? He would need to access it and add appointments to it.
Thank you for the help!
On Mon, 30 Aug 2004 22:15:24 -0700, "Gregg Hill" <firstname.lastname@example.org>
>I have one client on Exchange 2003 that wants to access the calendar of an
>employee (consultant?) at another company running Exchange (version no...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...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...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...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