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...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...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...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...mail sending problem
I am very new in the exchange server just now I have deployed
Microsoft Exchange Server 2003 at my organization now i have some
problem in that .
I am able to send mail outside the domain except yahoo .whenever I am
sending mail from my exchange mail id to any yahoo mail id it is
showing me mail has been sent but on yahoo id it is not delivering
even I am not getting the DFR, second I wants to know that can we
take the backup of single mail box (boxs) and please tell me step by
step how can we take backup (at least the location )
Thanks in Advance
The most probable reason is t...Receive mails from one adr. to several computers
I have a problem receiving mails from one adr. to 5
computers in a network. One of the computers get's all
the mails. They should all receive the mails.
All the machines run's win Xp and office Xp.
Outlook on all computers are set to store the mails on
the server, even though they have been received on a
computer. When I check my WebMail, the messages are still
...Can't send e-mails from Outlook 2003 after SP1
After installing service pack SP1 for Office 2003, I
can't send e-mails anymore. They are stuck in the outbox
folder. The error message states that the connection to
the server was interrupted. I did not change any settings
and checking them confirms that everything is as it
should be. Did anyone else experience the same issue and
how did you resolve it?
Thanks for your help
See if you can manually move those messages from your Outbox and then check
all your settings again.
"Mattliusa" <email@example.com> wrote in message
news:cb7401c48a5...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" <firstname.lastname@example.org> wrote in message news:email@example.com...
> 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...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" <firstname.lastname@example.org> 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.
...Incoming mail server problem
I use supanet for the internet and recently had to clear off a load of
viruses and worms from my computer. Computer is clean now. I've run up to
date spybot. adaware and cleaned all viruses with Mcaffee internet security
as well as running stinger. Sasser, and W32 pate.b were included. Have also
completed all windows updates.
Everything is working fine now except my email. When I restart the computer
my incoming mail server keeps changing from pop.supanet.com to a strange
number. 9eg 17.02.01.10 or something similar) It also changes the user name
from 3612 to email@example.com (It adds su...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...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...Mail is queued after adding 2nd server
I was hoping someone might have some insight into this issue.
I've just completed adding a 2nd server to my first site. All mail
between the two servers is getting queued; doesn't matter which server
it originates from.
Mail to the original server from the internet as well as auto
generated emails is still functioning correctly.
We're running Exchg 2003 SP2 and Win2k3 on both servers. I've also
gone through the Best Practices and fixed the minor issues it listed.
Can you telnet to port 25 from each server successfully? Are the servers
located in the same su...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...Outlook 2003 unable to open mails or contacts
After upgrading from Office XP to Office 2003 I am not=20
bale to access any item in Outlook 2003.=20
The Error message which will be displayed if I try to open=20
a message is:
Microsoft Office Outlook:
Out of memory or system resources. Close sone windows or=20
programs and try again.
Microsoft Office 2003 Professional is running on two=20
different operating systems:
One is running XP professional,=20
The other is running Windows server 2003 enterprise=20
Always the same result. If I reinstall Outlook from Office=20
XP Professional I am able to read all mails without any=20
fau...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.
Re...? types as an ampersand E
Why and how can I fix this? It happens sometimes, not all the time. Thanks.
Based on the information you provided, I would guess that your keyboard is
malfunctioning. The problem might be very different from that guess, but
there is not much information provided.
"Moberly" <Moberly@discussions.microsoft.com> wrote in message
> Why and how can I fix this? It happens sometimes, not all the time.
...Cond. Formatting depending of value in another sheet
I've tried to do conditional formatting whether the cellvalue i
another sheet is greater or smaller than the cellvalue I have in th
I've tried to do "formula is" IF(B34<Sheet1!B34)and format, but it won
Any help is apprecciated!!
Message posted from http://www.ExcelForum.com
"Jonsson >" <<Jonsson.email@example.com> wrote in message
> Hi all,
> I've tried to do conditional formatting whether the ...Checking mails with MS Outlook closed?!
is it possible to have MS Outlook notify me of new accounts in a minimized
status. i.e. i have a low memory and i don't want extra programs to be
opened on my computer. i want to have outlook closed still i want it to to
checkup my imcoming mails and provided i should have new mails it would
popup and notify me accordingly.
is that possible in outlook? if not, is there any program that could do
Outlook can't do anything if it's not opened. Is the mailbox you're checking
a POP3 mailbox? If so, there are a number of very small programs that c...Mail Merge #2
In Publisher 2002 is it possible to print a roster of
Mail Merge data base records showing multiple entries per
page? I'm essentially looking to print a phone book type
list with Able, Ann (222) 222-2222 on the first line,
Brown, Bob (333) 333-3333 on the second line and so on.
Any help would be appreciated.
Not difficult at all if you make a custom size small in height label the
width of the page.
The US should free all those
illegally held prisoners they are
torturing, abusing and denying
human rights being held at
...Newly acquired company mail?
I've been assigned a task that I can't seem to find any good info on while
browsing the net. Company A has acquired companies B and C and would like to
be able to give all newly acquired employees access to both e-mail domains.
This would effectively give all new employees two accounts (one from companyA
and the other companyB/C). I'm looking for a quick rundown on how best to
set this up. If anyone can help I'd be forever gracious.
1. You can Merge the accounts of B and C to the Exchange environment of
2. Configure Rec...excel count cell with color conditional formatting
Can i count number (sum) of cells in a column colored with conditional
the formula is =ISNUMBER(MATCH(D3;$AL3:$AR3;0))
(remove nothere from the email address if mailing direct)
"Marco" <firstname.lastname@example.org> wrote in message
> Can i count number (sum) of cells in a column colored with conditional
> formatting ?
> the formula is =ISNUMBER(MATCH(D3;$AL3:...