Re: PCWorks: Excel/ *.CSV help...(And Quick Books)

Keith Thompson Thu, 25 Mar 2004 10:04:25 -0800

The number you see is the mm/dd/year number equivalent. The only way you can keep the 9-1987 is to enter a ' first in the cell. Once you have entered that way, you can treat it as a text entry from there on. If you have a number to do, you might want to try making a macro which will insert the ' in the entry and then write to the selected cell.

Keith Thompson

Jeff Dougherty wrote:

Hi Carol,
Yes that does work...thanks so much for the extra time. ....but...
Try entering 9-1987. Transforms it into month/year. Try changing it to anything else 
and it's not even
close. (28734).
I'm going to see what the list Marlene sent has to say..
Thank you.
Jeff Dougherty
www.intrepid-video.com www.tech-repair.net

----- Original Message ----- From: "Carol Warman" <[EMAIL PROTECTED]>

Jeff:

I tried typing 123456789012 into a cell and, as you said, Excel formats it
as "General" and it shows as 1.23457E+11. This is exponential notation.
Formatting it with Text after this does not help, as you have deduced.

I then tried formatting the cell as "Number" with 0 decimal places and it
displays as 123456789012. I think this is what you want.

Give it a try and post back with results, please.

Carol Warman
-----Original Message-----Jeff Dougherty
www.intrepid-video.com www.tech-repair.net

----- Original Message -----
From: "Carol Warman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 24, 2004 12:48 PM
Subject: RE: PCWorks: Excel/ *.CSV help...(And Quick Books)

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
OK...I'm getting a little fed up with this excel program...why is this
program designed to change the values?
First, I have a database of info that I have to save with the commas to
import to their final locations.I can't open them while they are in the CSV
extension, because then the values, namely part numbers, will change to some
formula. I've asked for help on this a few months ago and no one had a
concrete answer for me.
Now, I have the option to export my inventory from Quick Books to CSV or
PRN. I never heard of PRN, so I chose CSV and what do you know, the parts
numbers are changed after the import.
I've created a new default template according to the help section and it
still does it.

Jeff Dougherty

-- Keith Thompson, Worthington, OH Home Web Page: http://freepages.family.rootsweb.com/~kthompson/ Genealogy Web Page: http://freepages.genealogy.rootsweb.com/~kthompson Never buy a car you can't push. ============= PCWorks Mailing List ================= Don't see your post? Check our posting guidelines & make sure you've followed proper posting procedures, http://pcworkers.com/rules.htm Contact list owner <[EMAIL PROTECTED]> Unsubscribing and other changes: http://pcworkers.com =====================================================

Re: PCWorks: Excel/ *.CSV help...(And Quick Books)

Reply via email to