csv import into excel, preserving leading zeros in numbers
We have csv file automatically generated where rows look like:
The problem is that when Excel opens this file it puts it into cells like
stripping leading zeros. Is there way to generate csv file so that leading
zeros won't be stripped so it would like
0123,0456,089 when the file is opened in excel.
rename the file a .txt file. Then you will have a choice for the type of
field, number or text
"Vadim" <firstname.lastname@example.org> wrote in message
new...Sending a mail .doc, others see all formatting.
Operating System: Mac OS X 10.4 (Tiger)
When I send a word doc to colleagues they can see all the formatting and editing. I cant see it on my screen nor when I print it out. How can I stoop this?
...SOP NonInventory Unit Cost 6 Decimal Places
Is there any simple way to increase the currency decimal places to greater
than the current highest value of 5?
I don't believe there is any easy or even moderately difficult way to do
this, as the field types used to store amounts in GP only go up to 5 decimal
Dynamics GP MVP
Flexible Solutions - home of GP Reports
"Scott Rutledge" <email@example.com> wrote in message
> Is there any...Merge data by macro
Hi all, I got data in column A and B as show below.
Row A B ......col
1 ID DATA ...headings
2 XY01 Record
5 XY02 Time
7 XY03 System
I need macro which should merge column B data and put result in column
C as shown below
Row A C ......col
1 ID DATA ...headings
2 XY01 Record Time Left
5 XY02 Time Right
7 XY03 System Record Ti...search work book in excel 97
how do i search a workbook in excel 97?
in excel xp i click the first sheet then shift click the last sheet to
select all the sheets, then click find, enter the info and it searches every
sheet in the book.
I have excel 97 at work and the same procedure only searches the first
is there a different method. in 97
thanks for any help
this is a change in the later Excel versions. Excel 97 does not support
this workbook search.But you may try Jan Karel Pieterse's FLEXFIND.XLA
Steve Goodrich wrote:
&g...mailbox is full in outlook 2003 but we cant delete the mails
we have the problem in outlook 2003 now no mails arenot downloading and
outgoing same time we cant save the mssages when its shows outlook disk is
full you cant save the mssage like this same time we cant delete the old
mails also please give me reply to solve this problem.
awaiting for your reply
p vasanth kumar
Hi P Vasanth Kumar,
have a look on this site:
2gb152.exe: "Specific support tool to create a truncated copy of a .pst file
allowing some recovery when the file size has reached over 2 gig"
http://www.microsoft.com/downloads/details.aspx?FamilyID=B33B1DFF-6F50-411D-B...Excel on the web #3
I am trying to put excel worksheets on my website and want
visitors to be able to open them as excel. In Netscape
only the code appears and in Explorer it opens but in
Explorer. The word files open word and the files look
fine in both Netscape and Excel. I have tried it on
different computers, MAC's, etc. but nothing. Is there a
way to do this or have the excel file download?
I have my users Right Click the mouse button and use the options there. (IE
You may be able to look at the MIME area of Internet Explorer and see if you can change how IE reacts. Maybe turn off th...Public folder does not receive external e-mails
When i send an e-mail to the new public folder with Outlook within the
domain, the e-mail arrives. When i send an e-mail manually to the Exchange
server, it says the message will be queued:
MAIL FROM: <hans>
250 2.1.0 firstname.lastname@example.org....Sender OK
RCPT TO: <email@example.com>
250 2.1.5 firstname.lastname@example.org
500 5.3.3 Unrecognized command
500 5.3.3 Unrecognized command
354 Start mail input; end with <CRLF>.<CRLF>
250 2.6.0 <ExchangebhsKd6QR7j1HaK00000073@Exchange.test.nl> Queued mail for
But it never arr...using the '&' and keeping the spaces
I'm trying to use the '&' function to assemble a line of data from multiple
cells, but i need to have spaces in the line of data for the spots where
there is no data in the cooresponding cell.
=IF(LEN(A1)>=1,A1," ")&" " & IF(LEN(B1)>=1,B1," ")
"durrrant" <email@example.com> wrote in message
> I'm trying to use the '&' function to assemble a line of data from
> cells, but ...Flash cards (Mail merge on 2 sided cards with multiple cards per s
I want to make a set of flash cards (3.5" x 2") with a term on one side and a
definition on the back side. I have all the terms and definitions in a
spreadsheet. I want to use sheets of tear apart business cards (10 cards per
8.5" x 11" sheet) Each sheet will create 10 flash cards with a unique term
on one side and definition on the back side.
I understand how to set up a mail merge but if I select “multiple COPIES per
sheet” the front and back of the cards are printed properly (definition and
the term match) but I get 10 copies of the same card per page. If I s...Debugging Excel-Start?
one excel workbook has a very long loading time.
How can I see, what excel does?
The workbook is several excel-versions old.
Maybe that is causing the long loading times.
With kind regards
F�hren durch pr�zise Daten
This is a multi-part message in MIME format.
You can add Stop statement to WorkBook_Open event or AutoOpen procedure. =
After that save the workbook, close a...windows mail
windows mail keeps telling there is an (An unknown error has occurred.
Account: 'pop.windstream.net', Server: 'pop.windstream.net', Protocol: POP3,
Port: 110, Secure(SSL): No, Error Number: 0x80004005) can any one help
i have every tning i can think of in geting this to work end the identities
will not work they keep saying imported or delited and can not go now were
"Unknown error" is usually caused by interference from an antivirus=20
program. Which antivirus are you running?
As a minimum, email scanning in the antivirus should b...Reduce currency decimals
Is there any tool which will reduce the currency decimals on our Great
Plains system. We want to reduce our system currency decimals.
I'm not sure if this is what you mean, but there's
Tools >> Utilities >> Inventory >> Change Decimal Places
This utility can change the decimal places for items.
I don't know of any system-wide change for decimal places.
> Is there any tool which will reduce the currency decimals on our Great
> Plains system. We want to reduce our system currency decimals....2007 outllook junk email message: Junk E-mail 
My Junk E-mail folder now reads: Junk E-mail 
Can't get the  to show only the number of any emails in the
folder. Have emptied it so there is no emails, but it shows up. The color
of the number is as if it is a "read" mail. What is it and how do I get rid
Right click on the folder and choose Properties and see if the folder is set
to show total number of items or total number of unread items.
"Rikki" <Rikki@discussions.microsoft.com> wrote in message
> My Junk ...EXCEL.EXE Process Open even though Quit method issued
I'm opening a workbook using the Task Scheduler built-in
Windows2000 and when the workbook is done doing what it's
supposed to do, I issue an Application.Quit method in the
VBA code to close Excel. In the Task Manager, the Excel
application (I'm using Excel2000) and the workbook that
was opened is not seen in the Application tab, yet there
is an EXCEL.EXE in the Processes tab. Also, going in the
Task Scheduler, the task itself is still running even
though I issued the Quit to get out of Excel. Either
stopping the task or ending the process gives me a dump in
the Dr.Wat...Import messages from Windows Mail to Outlook 2002?
I need to switch from Windows Mail to Outlook 2002. I have been able to
export and import contacts and calendars, but can't see how to export
messages or groups from Mail. Do I have to upgrade to a later Outlook?
If you want to use a supported version of Outlook, then yes, you'll need to
upgrade to either Outlook 2003 or Outlook 2007. Outlook 2002 has known
compatibility issues with Windows Vista which will not be addressed since
Outlook 2002 is out of mainstream support for quite some time now. One of
the most notable issues is that Outlook will not remember you passwo...decimal problem
I a very strange effect when using different decimal settings
and calculating some values:
DECLARE @Decimal1 decimal(5, 2)
DECLARE @Decimal2 decimal(30, 2)
SET @Decimal1 = 0.2
SET @Decimal2 = 0.2
SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal1))
SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal2))
The first result is correct (0.00000000025832000),
the second is wrong, why ???
Thanks for any comments
This is what happens when you multiple these precision&scales
15 + 3...Sync multiple e-mail accounts
I run Outlook 2007 and Windows Mobile 6. How do I get my contacts and
calendar to syncronize between my phone and two e-mail accounts on my
computer (G-mail and kiwilink)?
"Need to Sync" <Need to Sync@discussions.microsoft.com> wrote in message
>I run Outlook 2007 and Windows Mobile 6. How do I get my contacts and
> calendar to syncronize between my phone and two e-mail accounts on my
> computer (G-mail and kiwilink)?
Google Sync should work for gmail. I have no idea what "kiwilink"...Decimal
In a laboratory test we do the temperature has to be reported to the
Can anyone let me know how to format it so that when the result is a whole
number, it leaves the decimal point out?
eg 22�C or 22.5�C (not 22.�C or 22.0�C)
"Alan Cocks" <firstname.lastname@example.org> wrote in message
> In a laboratory test we do the temperature has to be reported to the
> nearest 0.5�C.
> Can anyone let me know how to format it so that when the result is a whole
> number, it leaves the decimal point out?
&g...How to create macro to e-mail a form?
I have created a Form in Word 2007 containing blanks to be filled in by an
applicant and then e-mailed. To facilitate the application process I am
trying to create a macro to allow the applicant to do the following with one
click of the mouse:
1. SAVE the just completed form
2. OPEN an e-mail to an address specified in the form
3. ATTACH the completed form to the e-mail
4. SEND the e-mail
Can anyone help?
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowled...history of excel
does any body knows the history of excel
maybe this is of interest for you:
> does any body knows the history of excel
A web search in google using " excel+history " would be a
good starting point. (670,000 answers)
Regards Bob C.
>does any body knows the history of excel
...Unique Excel records only
I am using Excel 2003, and I have three columns of data. Some of the
records of each of the three columns (a) have spaces between them and (b)
Is there a way to pull out the spaces (i.e. the blank records) and eliminate
the duplicate records?
In an attempt to filter out the duplicates, I went to Data...Advanced Sort
and checked the box "Unique records only". But, that was not correct. Some
duplicates and at least one blank record remained.
Any help on this would be thoroughly appreciated. Thanks.
"I went to Data...Advanced S...excel 2002 files not saved
When a file is created in excel and is saved. When I want to check the file it is not there but there is one file with alphanumeric number with extension file which is my excel file. looks like it is the temp file. can this problem be avoided so that it keeps the file with the given name.
When you save a file, excel will save it as a temporary file (8 characters, no
extension). Then if that save is successful, excel will delete the original and
rename this funny named file to the original's name.
You see the results when something interferes with this process.
A couple of things th...Outlook freezes after clicking on e-mail
We have a user who just started having a problem with
Outlook 2002. They click on an e-mail and then go to
click on another e-mail and Outlook freezes. She just
gets the hourglass and parts of the screen goes black.
Any ideas as to what is happening and how do we fix it?
...How do I remove spaces at the beginning of cells?
I have a column of names I need to sort. Unfortunately, some of the cells
have 1 or 2 leading spaces, which cause the zero-leading spaces to be sorted,
then the one-leading space, then two-leading space. And since there are over
3000 names to be sorted, doing them by hand is problematic.
Use a temporary helper column and enter a formula like this:
Copy that formula down as far as needed.
Then, select the entire range of formulas and do:
Right click>Paste Special>Values>OK
Compare the 2 columns and make sure the helpe...