double quotes

Hello,

Because of limitations in my finance program, I'll periodically
export the data to a text file, import the text file to Excel, where I
manipulate the data as required.  I then reverse the steps, saving the
Excel file as text, then import the new text file back to my finance
program.  It all works Ok except for one thing - the amounts are
stored in the program with a T in front, e.g., 100.00 would be T100.00.
 The problem is with larger amounts that involve a comma, such as
1,000.00 which would be T1,000.00.  Excel insists on saving it with
double quotes around it, "T1,000.00", which fouls up my finance
program, but not around T100.00.  I can run the text file through my
word processor and remove the double quotes, but I'd like to avoid
the extra step.  Any ideas?  Thanks,

Dave

0
dave.unger (36)
2/24/2005 6:17:12 PM
excel 39879 articles. 2 followers. Follow

2 Replies
1009 Views

Similar Articles

[PageSpeed] 22

Maybe you could write your own saver program.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly:  http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Kramer wrote:
> 
> Hello,
> 
> Because of limitations in my finance program, I'll periodically
> export the data to a text file, import the text file to Excel, where I
> manipulate the data as required.  I then reverse the steps, saving the
> Excel file as text, then import the new text file back to my finance
> program.  It all works Ok except for one thing - the amounts are
> stored in the program with a T in front, e.g., 100.00 would be T100.00.
>  The problem is with larger amounts that involve a comma, such as
> 1,000.00 which would be T1,000.00.  Excel insists on saving it with
> double quotes around it, "T1,000.00", which fouls up my finance
> program, but not around T100.00.  I can run the text file through my
> word processor and remove the double quotes, but I'd like to avoid
> the extra step.  Any ideas?  Thanks,
> 
> Dave

-- 

Dave Peterson
0
ec357201 (5290)
2/24/2005 9:00:49 PM
Dave,

After browsing those websites, I was able to write a simple but
effective program that solved my problem.  Thanks for this,

Dave Unger

0
dave.unger (36)
2/25/2005 6:30:38 AM
Reply:

Similar Artilces:

SOP and "service items"
I am setting up item codes that are strickly "service items". When I try to enter in a quote it requires me to enter the item into a "site". Since service items are non-inventoried items why does it ask for that? I set it up but now when I go to open the inventory availalbe to promise inquiry I am getting negative nubmers in as though they are inventoried item... Any ideas what I didn't setup correctly? Thanks, S Sherry, >I am setting up item codes that are strickly "service items". When I try to enter in a quote it requires me to enter the ite...

Error "Information is needed before this report can be processed"
Error: "Information is needed before this report can be processed" This is said to occur when you run MS CRM on a win 2003 and the Active Directory on a win 2000 for all users except the ‘admin’ user which CRM was installed with. However... It occurs as well on “Win Std. 2003 SP1” vs “Win Std. 2003 SP1” and I have no clue what to do about it :( and would really appreciate some ideas. I have also been told that there was a fix for this and this fix was included in Win 2003 service pack 1, but the problem remains. There might also be a related problem, when running reports a...

Outlook 2002 "MAPI unable to load..."
I recently began using Outlook 2002 when I needed to synch my PDA. For the first 4-5 weeks there were no real problems. LAst week I downloaded an add-in from Microsoft's Office area: Outlood Personal Folders Backup - But now when I start Outlook I get the message: "Unable to open your defaolt e-mail folders. MAPI was unable to load the information service PSTPRX.DLL." I have done REPAIR twice and then tried UNINSTALL/INSTALL. Nothing seems to help. Any ideas would be appreciated. If it is the add-in, how do I remove it?? OL2002: Error Message: MAPI Was Unable to ...

Manulipate "Open With" Menu
How can I manipulate the "Open With" menu in Windows 7? I have applications I would like to have an option to use on certain types of data, and "Open With" seems like the perfect solution if I could only add my choice to the list. For example, use VLC to watch a .iso move file. Windows 7 only gives a choice to burn the .iso file to my DVD burner and I would like to ad an application like VLC to the "Open With" list so I have the option to also watch the move. Thanks. In article <549E3A2A-1AEC-4D47-943A-DCE6A3842AAB@microsoft.com>, gcat...

"Format bar" "middle color" programmatically
I need to change the color of the gantt bar programmatically based on the percentage completed of the matching task. I could not figure out what the object responsible name is. Any ideas? Are you sure you are in the correct newsgroup? Try this, it is for Project Create a custom Gantt bar http://office.microsoft.com/en-us/project/HP453038731033.aspx Format the bar chart portion of a Gantt view http://office.microsoft.com/en-us/project/HA012253681033.aspx -- Mary Sauer http://msauer.mvps.org/ "W" <sedky69@gmail.com> wrote in message news:5459011b-30ad-41f5-876e-7a476d6bf5...

double quotes
Hello, Because of limitations in my finance program, I'll periodically export the data to a text file, import the text file to Excel, where I manipulate the data as required. I then reverse the steps, saving the Excel file as text, then import the new text file back to my finance program. It all works Ok except for one thing - the amounts are stored in the program with a T in front, e.g., 100.00 would be T100.00. The problem is with larger amounts that involve a comma, such as 1,000.00 which would be T1,000.00. Excel insists on saving it with double quotes around it, "T1,000.00&q...

Hiding the "#N/A" value
How does one hide this value so that it isn't visible in a cell. Also; it appears that when I try a simple calculation of cells; and one of those cells has this value listed in it; my calculation does not complete. How can I correct this? 1. =IF(ISNA(myformula),"",myformula) 2. Usually, it means one is formatted as text or has spaces in it or something. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "theslaz" <slaz@home.com> wrote in message news:NZ2ue.73345$on1.9727@clgrps13... > How does one hide this value so that it is...

MS Office "Save" dialog obscures the document you are saving??
I've just moved to Mac OSX (Panther) from OS9.2. I've been using MS Word for years. In Office X, Microsoft, again, appears to be using it's own "Save" dialog rather than the ones that are part of the Mac OS. (Microsoft has done this in all previous versions of Word and Excel, and that included the "Save," "Save As . . . ", and "Open . . . " dialogs. And, yes, I know I am dating myself by calling these "Dialog" boxes.) But, it appears that the Office X "Save" dialog obscures at least the upper half of the file you are sav...

How to find out the "current" user ?
Hi: I have a question on how to determine the "Currently" logged on user in Win-XP). I can use NetWkstaUserEnum() to get a list of logged on users, but how to determine which user is the one who currently own the active desktop ? And one more, even after log off the machine, some times, an account (domain\user) is still got returned by the NetWkstaUserEnum, why is that? Thanks in advance! Polaris How about this function? NetWkstaUserGetInfo(...); AliR. "Polaris" <etpolaris@hotmail.com> wrote in message news:uHGl6zedFHA.2520@TK2MSFTNGP09.phx.gbl... >...

"unable to display the folder. The ... folder could not be found" error
All, The above error occurs for a set of users delegated mailbox access. Selecting file-open-other user's folder results in this message. It seems to be a particular OU as other users mail opens okay. Has anyone experienced this error? Please email me. Regards Derrick Smith ...

What does the "I" stand for?
.... for example in IAccessible or IUnknown? Is it "interface"? Thanks! Jeff Caton was thinking very hard : > ... for example in IAccessible or IUnknown? > Is it "interface"? > > Thanks! Yes. -- Michael Cole Jeff Caton wrote on 6/11/2010 : > ... for example in IAccessible or IUnknown? > Is it "interface"? > > Thanks! Yes it is Interface -- ClassicVB Users Regroup! comp.lang.basic.visual.misc Free usenet access at http://www.eternal-september.org Thank you! "Gutless Umbrella Carrying Sissy&qu...

(APPZ) Ashampoo.UnInstaller.3.v3.1.3.0.incl.Keygen.WinAll-LAXiTY
=ybegin part=1 line=128 size=6003 name=Ashampoo.UnInstaller.3.v3.1.3.0.incl.Keygen.WinAll-LAXiTY.nzb =ypart begin=1 end=6003 fi���J�������gL[XZLJ��������gL���WbLJih74fKnym~�zoJ���JzlvsmJLWYY����l��YYn~nJx�lJZXcYYoxLJL����dYY���X�������X���Yn~nY���Y���W ZXcX���Lh74f���J�����gL����dYY���X�������X���Yn~nY\ZZ]Y���Lh74JJf����J������gL��������bbj������W����X���JR��������SLJ����gL[\`_b baaZ[LJ�������gLRkzz�SJk�������X�s��������X]X�]X[X]XZX����Xu�����X���k��Wvk��~�JWJPM�\\ek�������X�s��������X]X�]X[X]XZX����Xu� ����X���k��Wvk��~�X���PM�\\eJ�[Y]�JR[Y[SLh74JJJJf������h74JJJJJJf�����h���X������...

budget "subcategory blank"
Greetings! On my annual budget report one of my main categories with (five subcategories) is showing up as "subcategory blank". I checked each transaction and every one is assigned to a subcategory but none are showing. Might anyone have an idea? Thanks, TS It sounds like the subcategories are not part of your budget, just the main category. Add them in, and this should include a budget entry for the subcategories in question (you may wish to take a copy of your Money file/budget first, before trying this). -- Glyn Simpson, Microsoft MVP - Money http://money.mvps.org Check h...

Form with multiple "tabs"
Hi I am trying to create a survey in access but would like to separate the form into sections: General, School, Family, Relationships, Needs. Instead of creating 1 single form, what I would like to have are "tabs" for each section. How would I go about and create this? This is very simple. Just pick the 'Tab' control on the toolbar and click on your form to make an instance of the tab control there. It starts with two tabs, but you can right-click on the control and select 'Add page' as many times as you need pages. Other controls are picked fr...

Double email
Keep getting duplicate email? No where to find out how to change that, nothing in options or custom. Nothing in your post to help anyone try to help you. Version of Outlook? Type of account? How many? Did this always happen? When did it start? What did you change just before it started happening? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After searching google.groups.com and finding no answer Barbra <b.kostka@att.net> asked: | Keep getting duplicate email? No where to find out how to | change that, nothing in options or cu...

Money Plus Deluxe "Sunset" Version is Available
The Money Plus Deluxe "Sunset" version is available for download. Go to http://www.microsoft.com/downloads/ and enter "Money Sunset" into the search box. This is a version of Money Plus, so it cannot be installed simultaneously with a regular Money Plus version. It can read and write Money Plus files, and it can also convert Money 2007 (and 2006 I suspect) Standard, Deluxe or Premium files. It may even convert the Money Essentials and MSN Money files. The business version will be posted later. I don't know how it will behave with a Canadian file. The B...

Visio Hyperlinks
Hi - currently using Visio and would like to save the workflow as a template for others to 'save as' and execute - need to know if the hyperlinks will work within the template and also whether or the current hyperlinks require a 'right click' to execute???? Would like to execute using double click feature? Any advice would be GREAT!! Thanks..../d If you have a Hyperlink on a Shape, then change the formula in the EventDblClick cell in the spreadsheet to =HYPERLINK(Hyperlink.Row_1.Address) "Deb" <Deb@discussions.microsoft.com> wrote in message news:2E...

Creating a Line Chart with double Y Axis
Would be possible to create a Line Chart with double Y Axis on th Chart? The X axis is date and Y axis will be the value. Thannks -- Message posted from http://www.ExcelForum.com Select a series that you want on the secondary axis Choose Format>Selected Data Series On the Axis tab, select Secondary Click OK parker_yuan < wrote: > Would be possible to create a Line Chart with double Y Axis on the > Chart? The X axis is date and Y axis will be the value. Thannks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

How do I turn on "pressing enter goes to the next cell" option?
This is going to sound terribly dumb, but I used to be able to press the "enter" key and the next cell in the column would become the active one. Randomly however this ceased to happen. Can anyone please advise as to how I can re-activate this option? <Tools> <Options> <Edit> tab, Check "Move Selection After Enter", And choose direction. -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Hollywood" &...

WLM sending duplicate (double) emails
I have an annoying issue with WLM version 14.0.8089.0726 running on W7. Sometimes I send a mail from my MSN.com account and it sits in my Outbox for hours until I close WLM and then reopen it. This results in the mails in the Outbox being sent twice; in the "Account" column for one message it says my MSN mailbox name, and on the duplicate message the "Account" column is blank. Is anyone else having this issue? In Tools|Options on the Send tab, is the "Send messages immediately" box checked? -- Patrick P. www.boydcomputersvcs.com "...

Using "IF" in a Formula
If I enter the word "bounced" in one cell can I trigger a value in another cell ($500.00) to become a negative number (-$500.00)? Regrads, Corey Brock =IF(A1="bounced",-500,500) or if the 500 is from another cell =IF(A1="bounced",-H5,H5) The formula has to be in the cell that is to change. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ----...

"Something" is overriding my Format!
Hi! In our Excel timesheet templates, the cells are formatted with the Number cell with 2 decimal places. When the user types in their time (ie., 8 hours) and moves out of the cell, it should convert the 8 to 8.00. "Something" is overriding the format, however, because the 8 is changing to .80 instead. Does anyone know what is happening? Thanks! Jessi Hi goto 'Tools - Options - Edit' and ucheck 'Fixed decimals' -- Regards Frank Kabel Frankfurt, Germany Marcia wrote: > Hi! In our Excel timesheet templates, the cells are formatted with > the Number ...

Double the Attachments
Any idea why some of our emails have two copies of each attachment? At first I thought it was a sender fluke, but have recently noticed that some of our own sent e-mail messages, but not all, end up in the 'Sent Mail' folder with twice the attachments they had when originally sent. Do we have an errant setting that could be causing this anomaly? ...

Item has already been added. Key in dictionary:"winbootdir" Key being added: "winbootdir"
When I create a instance of web services proxy in winform, I get the exception. Stack Trace: System.ArgumentException: Item has already been added. Key in dictionary:"winbootdir" Key being added: "winbootdir" at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at System.Collections.Specialized.StringDictionary.Add(String key, String value) at System.CodeDom.Compiler.Executor.ExecWaitWithCapture(IntPtr userToken, String cmd, String currentDir, TempFileCollection tempFiles,...

Bank Transfer " Access to CheckBook denied"
I have quite a strange problem. I have a user who is failing to Transfer funds from one CheckBook to another. Under Bank Transfer Entry Window when the user tries to select a CHECK BOOK ID he receives a message that he does not have access to CheckBook. But the funny thing is that the user has been granted access to the CHECK BOOK under CHECK BOOK Acess. And I checked his status in the Check Book table and its set to 1. I have refreshed security permissions for the user under Advanced Security for forms,reports and smarlist for the Cashbook Model. Any ideas where I should start lookin...