Working with Excel #2
I have the following problem - I am needing to represent in Excel a number
with 20 (or more) digits. How can I do this?
> I have the following problem - I am needing to represent in Excel a number
> with 20 (or more) digits. How can I do this?
That is only possible with either:
- an addin (search google, there should be something for this, I recall
seeing it but misplaced the link).
- or by formatting the cell as text (but you won't be able to do math with
the number easily then)
Jan Karel Pieterse
www.jkp-ad...Windows Vista Service pack 2
I get automatic updates from Microsoft. Everytime my computer tries to
install Windosw Vista Service pack 2, it always fails. All other updates are
marked as successful however this Windows Vista Service pack 2 has failed
about twenty times. What can I do? I assume this is an important update but
my computer just will not allow for this update.
Free unlimited installation and compatibility support is available for
Windows Vista SP2 issues until 26 February 2010. Availability of chat or
e-mail support differs depending on your geographic location. Some issues
may requi...Adding custom pages to Windows Control Panel using MFC
Is there anybody know how to add a custom page to Windows Control Panel
using MFC? I found some code on Internet but that was written in Win32
API. Also tried to find the material on MSDN but the content is pretty
old (if I am correct) :
Is this what you're looking for?
<email@example.com> wrote in message
> Is there anybody know how to add a cus...printing error handling issue? (when clicking cancel get 2501 error)
I have a report that when it is closed the
DoCmd RunCommand acCmdPrint occurs ... but of course if the user clicks
cancel, it gives me
a 2501 error.
How & where do I put code to surpress this error. I would just the close
even to run the
DoCmd RunCommand acCmdPrint and if cancel is selected just continue to close
I understand that I have to do this, I actually don't understand HOW to do
it, and where to put code to accomplish this??
1) What code do I use?
2) Where do I put the code?
"Duane Hookom" <duanehookom@NO_...Search utility does not work for media files.
I have all media files associated with Winamp. I used to be able to find
files using the Windows XP Search utility, but now if I specify Winamp media
file in the Type of file field, then zero results are returned. It will still
work if I do not specify a type of file (leave it on All Files and Folders),
but searches take considerably longer this way.
"Barry_M" <BarryM@discussions.microsoft.com> wrote in message
>I have all media files associated with Winamp. I used to be able to find
> files usin...why i can not run excel2000 in windows XP?
i have installed office2000 in windows XP correctly, but i
can not open it. after the splash window, there are nothing
please tell me why i met that mistake and how to resolve it.
thank you for your help
The following MSKB article may help:
OFF2000: Program Quits Immediately After Starting When SR-1/SR-1a Update
> i have installed office2000 in windows XP correctly, but i
> can not open it. after the splash window, there are nothing
> please tell me why i met that mistake ...Covered calls getting exercised not working properly
I'm using MS Money 2006 Premium edition and it's missing a key piece of
executing a covered call. I can enter the initial sale of the call itself
without a problem (sell to open) but if the call gets exercised, MS Money
doesn't let me chose which shares will be called away.
So, if I sold one call (represents the potential sale of 100 shares) in MSFT
and I own 200 shares of MSFT (purchased in 2 lots of 100), if the call is
exercised and I enter the Activity "Exercise," Money goes through all of the
proper steps except it doesn't prompt me for which 100 share...[Windows 7] Move "Show Desktop" to the left side of taskbar, how to? (w/pic)
I want the "Show Desktop" button to be by the start button like it was in XP.
How to do that?
Pic is self-explanitory -->
On 29/11/2009 13:32, G. Morgan wrote:
> I want the "Show Desktop" button to be by the start button like it was in XP.
> How to do that?
> Pic is self-explanitory -->
I use outlook 2002 on a Windows NT SP6a machine. While using outlook,
i have noticed that sometimes the keys c, v, t and h stop working.
however, i can use them in notepad. i can also use them in outlook if
i put the caps lock on and use the shift key. if i restart outlook,
the problem goes away. sometimes the problem goes away as well on its
own without having to restart.
any idea what is happening? language is set as english (Australia)
...Windows SBS 2008 domain purchase and configuration wiza has stoppe
when clicking setup your internet address in windows SBS console, i select
already have a domain name and i will manage it myself.
a few seconds later i get the error "Windows SBS 2008 domain purchase and
configuration wiza has stopped working"
the only choice is to close the program.
What do i need to do to fix this error without reinstalling everything?
Is your server up to date with all patches? In particular, SP2?
Microsoft has opened the Small Business Server forum on Technet! Check it
http://social.technet.microsoft.com/Forums/en...Probably a hardware issue, but...
....it only seems to happen while using Outlook 2003.
Basically it has to do with mouse/pointer losing the focus. For example,
While a mail message is selected in any mail folder, the selected message is
"blue". But without warning or any action on my part, the focus will "go
away" and the seleceted object becomes "grey". I must them go back and click
on that object to make it active again.
This also seems to happen when I am in a dialog box of some sort. Even right
in the middle of typing, the focus on the dialog box gets lost and I cannot
continue typing ...Excel 97 on Windows XP data sort error
I have had sorting errors using Excel 97 running on
Windows XP. Is there a fix for this? I check Excel
updates and the microsoft website says I already have all
Please tell what sort of errors.
"Steve P" <firstname.lastname@example.org> wrote in message
> I have had sorting errors using Excel 97 running on
> Windows XP. Is there a fix for this? I check Excel
> updates and the microsoft website says I already have all
Sort errors are almost always data problems. You might have numeri...Outlook doesn't open in the inbox work space. Open up in the Outlook today works
How do I make the Inbox as the default workspace in
Outlook 2000 corporate mailbox. running on Win xp.
...Can I run proprietary Windows Software on Remote Desktop?
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I am using a PowerPC G5 Mac Mini. I am taking a course that requires a minimum of Windows XP or Vista. Can I install the course software on Remote Desktop so that I can use it to take this class, or is this just for using MS Office programs?
Also, what is the cost of this service?
On 3/24/08 12:03 PM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <email@example.com> wrote:
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: Power PC
> I am using a PowerPC G5 Mac ...Quicken to Money 2006 import issues
I tried the import wizard for the Money 2006 trial edition to get 5 years
worth of data from my quicken 2003 data file and Money had issues with the
file and wouldn't import.
I did find I could export the quicken file as a qif and then import it into
Money, but there are still some issue:
1. my expense catagories need to be applied to each transaction again
2. All the transaction are marked with a status of (E) when they all but
the most recent should be marked as reconciled (R).
If the only way around this is to change each transaction manually, I guess
I'll have to do it (5...Strange connectivity issue
Windows XP SP3, Dell laptop. Cannot ping the default gateway, which is our
router. Can ping any other computers on the subnet, either by hostname or
IP. Other computers on the subnet can ping this laptop, either by IP or
Cannot ping the laptop from the router.
The laptop has built-in wireless. If I enable that, I can ping the router's
I tried resetting TCPIP with this command:
Netsh int ip reset
Windows firewall is disabled.
The computer does not appear to have any viruses.
Nothing in Event Viewer.
I'm stumped. Any ...looking for control to display dialog similar to VC NET option window
I would like to implement a dialog similar to the VC++ NET options window.
left side of the options windows contains a tree control used to select
general category of options that will be viewed/edited. The right side of
window displays an dialog that allows the user to view/edit specific
options. Are there any shareware/commercials controls available that
provide this functionality? Thanks in advance.
I think I've seen something like that in www.codeproject.com (and for
We have recently migrated to a new exachange server, still running 5.5 though. We reconfigured all of the outlooks clients to point to the new server.
For some reason, some of the clients continue to function slowly, with a message coming up saying something to the effect of "Please wait while outlook accesses data from FS1 (the old exchange server)". So the clients are looking for something from the old server, which is no longer. We have totally wiped all email settings multiple times, but the problem continues.
What about Public Folders? Did you replicate them ov...How to add controls to window in code (.cpp)
I'm a newbie trying to add some controls to a window in a .cpp file.
More specifically, I created a .NET 2003 C++ MFC Application, called it TestGUI
In the function BOOL CTestGUIDlg::OnInitDialog(), I adde
CSliderCtrl *pSlider = new CSliderCtrl()
pSlider->Create(TBS_VERT, CRect(10,20,40,60), this, 2000)
This compiles and runs, but the slider does not show up . What is wrong
Hi Vufgar -
CSliderCtrl *pSlider = new CSliderCtrl()
pSlider->Create(WS_CHILD|WS_VISIBLE|TBS_VERT, CRect(10,20,40,60), this, 2000)
Oh yeah, I forgot to tell you. Con...CTL-END not working as expected
CTL-END should select the last cell in a worksheet. I have a workbook that
contains a worksheet used to store transactional data. The 12/31/08 sheet
had 15401 rows of data and CTL-END always selected last cell O15401.
Each week, I copy and paste the new transactional data from one workbook to
the worksheet in my master.
The latest 2009 data worksheet has 726 rows of data and CTL-END properly
select O726 within that sheet. However, after copying and pasting (using
CTL-A to select all data in the source and destination sheets, then pressing
CTL-Cin the source sheet and CTL-V in the desti...How do I change the color of tabs in word 2008 notebook layout?
I've been trying to figure out how to change the color of the section tabs with no success. Does anyone know how to do this?
In article <firstname.lastname@example.orgR9absDaxw>,
> I've been trying to figure out how to change the color of the section tabs
> with no success. Does anyone know how to do this?
Right- or ctrl-click the tab and choose a color from the Section Color
I'm looking for the same thing; in addition - how to delete extra tabs.
Ctrl-/right-click a tab, and you can change its colour as well as delete the
tab (a...[MDI] add a control to a client window
I have a standard MDI MFC project with all the default settings. How can
I add a control to the Client Window (CXXView) ? Is there maybe a simple
example around ?
Well It all depends on what type the View inherits from. If it is a
CFormView than you simply create/modify the dialog template associated with
If it's a simple CView, then you can create the control dynamically, using
it's Create method.
The type of View you use depends on what type of information you want to
display in the view. For example (and these are just examples of what you
would use these classes for...My Tasks (tasks.aspx) doesn't work on my machine, but does on othe
It would appear that something on my machine has broken. When I go to the
homepage of our project server site it won't even load if the My Tasks
webpart is on the page. If I remove it and reload the page everything works
fine. All of the other users in my dept are able to get to the page whether
My Tasks is on the page or not. Any thoughts?
I am the admin (I know, I know, I should be able to fix this, I'm the admin)
so I have rights to login and make server level changes, just need help
figuring out what is wrong. Since it's only on my machine I assume it has
...Character Spacing Issue
I created a document in Word on an XP machine. When I opened the same
document in Word on my Mac, the character spacing was noticeably
greater, although the font was the same (Franklin Gothic Medium). This
caused the layout to be altered as text that originally took one line
ran over to two. I have since opened the same document on my same
machine using OS X as well as my Windows Boot Camp partition. It is the
exact same document but it looks terrible on the Mac. Is there any way
to fix this?
The disparity is most likely caused by a difference in printer drivers &
print settings on the X...Memory allocation in Windows XP
Can Visual Studio 2005 allocate and use most all of the possible 4.0
GB of memory in Windows XP, or are there issues with this? In this
case we assume 32-bit development in a 32-bit OS.
Are there any issues with memory allocation and usage with Microsoft
Windows XP Professional x64 Edition and 32-bit development?
> Can Visual Studio 2005 allocate and use most all of the possible 4.0
> GB of memory in Windows XP, or are there issues with this? In this
> case we assume 32-bit development in a 32-bit OS.