Problems with reading date/time format from SQL server
I made a pivot table. I get data from external source - SQL server. On
of the columns is date/time type. For some reason unknown to me, Exce
doesn't read this dates correctly. Instead of dots between months an
days it puts little squares .. ?!? I opened the same file on m
coworkers comp. and it works just fine.
If anyone has already encountered this and knows how to fix it ..
Message posted from http://www.ExcelForum.com
There may be some difficulties getting external data properly into
Excel. If not done correctly you cannot use the data in formulae e....Paste Special Changes Content
Greetings - I am attempting to copy and link, via Past
Special, a group of rows within the same workbook. When I
do, all the empty cells are populated with zeros.
I am using Windows 200 and Office XP. Thanks in advance,
When you paste special|Links, you end up with a formula like:
If x99 is empty, then excel will show a 0. But you can change your formula to
look like this:
(if x99 is empty, then make the cell look empty, else just show what's in x99.)
> Greetings - I am attempting to copy and link, via Pas...format changes when copying from one cell to another
I'm sure this is simple, but it is not clear to me...
I am copying the contents of a group of cells that exist on one worksheet to
another. In Sheet2, I tell cell A1 that it should equal Sheet1's A1 value.
That works fine. But if the cell is blank on Sheet1, it comes up as "0" on
Sheet2. I figured it was probably assuming numeric formatting, but when I
right-click > format cell on both Sheet1 and Sheet2, both show up as
"general", so why would Sheet2 take a blank value and populate it with "0"
I gather than you are putting a formula in one...Date format in a report
The date is formatted in my table in yyyy/mmm/dd. In one report I need to
run for another organization the format needs to be in dd/mmm/yyyy format.
How can I change the way it displays in the report? I do not want to change
it in the table as I generally want the format to be yyyy/mmm/dd.
You can simply use either the format property for the control or you can use
the Format() if you need to set the format to something that doesn't already
Hope this helps,
http://www.carda...How to change .pst file location on hard drive(s)?
I want to move my .PST file c/w archives to a partition other than C:\. How
can I do this with Win Live Mail?
"Machinist60" <e_john_wilson.no.spam.@hotmail.com> wrote in message
> I want to move my .PST file c/w archives to a partition other than C:\.
> How can I do this with Win Live Mail?
> Thanks, John.
I didn't realize WLM utilized the .pst file. I had to convert my .pst file
data into the Windows Mail format and then import the data into WLM. Please
explain what you...Reformat data to vertical format
Here is what I am trying to do.
I have about a thousand records that I need in a vertical format with
normal shared field name. Any suggestions
Psydwaze's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2437
View this thread: http://www.excelforum.com/showthread.php?threadid=37965
Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel/snakecol.htm...Format Issue of Windows Mail and M.S. Group
When clicking to open any mails including this site, MS Newsgroup, top
right pane of 'X' part is not visible.
In the past, I used 'Shove-It' program that was found on the web-site,
priced $15 that corrected this issue. However, this program is no longer
effective, thus it went back to the original format, .... not fully opening
content of mail of right side of pane, although I can read any mails by
using 'maximizing bvutton' to open in full.
Any imputs on this, above would be greatly appreciated.
"Winter10" <Winter10No...Report Detail section coding
Is there a way I can know when the detail section of report moves to the
first record of a new group. Something like.....
If Me.DetailSection.BOF Then
I am using Access 2007
Any help is always appreciated.
>Is there a way I can know when the detail section of report moves to the
>first record of a new group. Something like.....
>If Me.DetailSection.BOF Then
>I am using Access 2007
Add a text box to the detail section and set its expression
to =1 and RunningSum property to Over Group. The value of
the te...Transferring Field from Existing Table/limitations and change of d
Thank you in advance for your help! I have two Excel spreadsheets that I
successfully imported into Access 2003 and created tables for. I need to add
the field from one table to the other, but there is not a direct match in the
relationship. The large table uses the Employee ID as the primary key. The
smaller table contains one field that lists a subset of these Employee ID
numbers (a selection of certain employees). I need to transfer this field to
the larger table, but I do not know how to tell Access to match up the
corresponding numbers (i.e., the large table lists all employees, bu...format negative dollars
We have 2 computers in this office, both with Office XP
On one we get ($ 4.00) on the other we get -$ 4.00 This
format seems to vary from file to files. Is there a way
to set the default on Excel to ($ 4.00) ?
It might help to check the Regional Settings in the
Control Panel (I assume your using windows). It
has settings for currency and number displays
which will affect excel. Check if yours and your
co-workers settings are the same.
"doug loewen" <email@example.com> wrote in message news:firstname.lastname@example.org...
> W...outlook 2003 inbox format
How can I eliminate the "Today", "Yesterday", "Last Week", etc? I much
prefer the look of Outlook 2000.
View > Arrange By > Show in groups
"Trng Administrator" <Trng Administrator@discussions.microsoft.com> wrote in
> How can I eliminate the "Today", "Yesterday", "Last Week", etc? I much
> prefer the look of Outlook 2000.
> Thank you
neo [mvp outlook] wrote:
> View > Arrange By > Show in groups
That...no change pivot item.
i want to can not change pivotitems in the pivotfields.
namely pivotitems restircted.
How can I do in VBA?
*** Sent via Developersdex http://www.developersdex.com ***
...Data changes when Analyzed with Excel
I have a query with 3 tables that represent master item list, count qty and
as qty. When I look at the results in Query, all is well and accurate yet
when I select Analyze with Excel, values change. For example, if a record
shows zero qty in the as of field and zero quantity in the count field, I get
a value in one or both of the fields that origianlly were zero. Other than
linking the tables and grouping by master item list (to show all parts
regardless of qty's), there are no formulas or expressions in this query.
One of the tables is linked to a FoxPro table via ODBC driver.
...Change Source Campaign on Invoice and Order
I need to change the Source Campaign on an Invoice and an Order but the field
is locked. I tried to enable the field on the form but still cannot make
changes. Any ideas beyond direct edit of DB?
...Excel 2000/Change Default Opening Location?
I'm using Excel 2000. When I open Excel, and the click on
the Open button to open worksheet, it goes to a default
location I'd like to change. How can I change that default
I have searched under Tools > Options, but find no means
Former slayer of dragons; practice now limited to sacred
cows. Believing we should hire for quality, not quotas, and
promote for performance, not preferences.
change the entry in the Default File Location box
> I'm using Excel 2000. When I open...Duplicate entries & Conditional Formatting
Is there a formula indicate duplicate data on 2 different worksheets? I
want the font to change to bold.
Yes, provided it is a named range within the same workbook.
Select the cells and Format>Conditional Formatting>Formula Is>
Format for the change if TRUE.
Greeting from the Gulf Coast!
"hmm" <email@example.com> wrote in message news:3FCCCF2F.42E759CF@hmm.com...
> Is there a formula indicate duplicate data on 2 different worksheets? I
> want the font to change to bold.
...Equivalent Column Break
In MSWord you can insert a column break when doing newspaper columns. If I
have two text frames connected, and I am almost at the bottom of one but want
Publisher to start at the top of the next one, how do I insert a 'break'? or
do I have to press return until it move the text.
(1) You could shorten that column so that your text breaks where you want it
(2) Or you could check the Help file and search for "insert break".
Insert a column break
You can insert a column break anywhere in a text box. If the text box
contains more than one column, the ...Powerpoint with Excel formatted information
My team has an excel file with Text and Icons in a status report format.
We use it to copy and insert paste into Powerpoint. After copying into
Powerpoint, I try to select it and edit but powerpoint gives an error that
"There isn't enough memory available to read the Excel file"
Other team members use this same excel template and powerpoint and they can
edit the information after it is copied to powerpoint. And I can use their
files and they work fine. Only one team member has this issue so somehow
this person's excel file is using a massi...POP server always changes to localhost
My outlook is having a wierd issue. I have three POP3
accounts set up to check email in Outlook. After some
point in time, all three will stop functioning because in
the E-mail accounts settings dialog my incoming mail
server will get changed to localhost, and it fails to log
in to box to pull my mail.
It appends the POP3 server name to my user name which
So, to summarize, my Incoming mail server (POP3) field
changes from it's usual value (something like
mail.server.com) to localhost, and my mail server gets
appended to my user name (something like
username...Re: Recovery from EX2000 to EX2003 Server on a new machine
i have been having serious problems with my current Exchange 2000 machine where it continously fails to load the Information store and other services at startup. i have got it up and running now but if i reboot it will fail again and only starts 1 in 10 reboots
What i would like to do it create another box with Windows 2003 and Exchange 2003 and move all the stores,logs and all to this new server. Is there any procedures that need to be followed to do this? and are there any complications with the AD
please advise me on the correct was to do this or any documentation there is available...Help with cells auto formatting
I have posted a similar question before however I never really got this
sorted so sorry for repeating myself.
Basically I use two spreadsheets daily at work all with various information
on and various formats in each Column. My problem is when I close the
spreadsheet and reopen it the cells that are formatted as 'general' or
'number' turn into Euro currencies.
Does anyone know why this happens or how I can stop it? The spreadsheets
aren't stored locally they are stored on a serve that only myself and my boss
can get onto and we both have the same p...protect formatting #3
I have a shared workbook with many worksheets in it that many people need to
fill in. How can I protect the formatting of it so that they cannot change
it. Also when they copy and paste things into the worksheets I would like the
format to revert to how I have set it??
Is this available/possible?
The difference between engineering and Scientific is that engineering is
always in the form of "11.11En where "n" is a multiple of 3.
AFAIK this is not possible in Excel
"Bill Allen" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Is this available/possible?
> The difference between engineering and Scientific is that engineering
> always in the form of "11.11En where "n" is a multiple of 3.
&g...Prevent conditional formatting from being override
E.g When I copy a cell (sheetname = "Main" with normal data + comment) to
worksheet cell (sheetname = "test") with conditional formatting , the
conditional formatting is gone.
How to prevent it? Paste value only?
Yep - If you can't protect the cell then you need to use edit / paste
special / values or formulas etc
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgivenes...conditional formatting not working in every cell
I have a worksheet that has conditional formatting set for an grade that is
below 95 to turn red. The total worksheet has 160 entries and the formatting
works on most of the cells except 4 vells show a grade of 95 and its in red.
There are several other cells that are at 95 and are not red. I did a paste
special across the worksheet, I have also tried to change the cell itself and
I still get the same problem. Any way to fix this?
Is it possible that your CF refers to the cell above or below the actua
i.e conditional formatting in B2 looks in B1 or B3
Something to look into.