LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nuno
 
Posts: n/a
Default Problem with txt format

Hi everyone!

I was wondering if you cound help with a problem I'm having with Excel. I
have a list of codes that I want Excel to save in txt format with the "".
I'll explain: I have thousands of codes in a numerical format (e.g. 3173471;
3174742, etc.) but I need to save a txt file that puts "" around the value,
i.e., "3173471", "3174742", etc. I've tried to use the concatenate function,
replace and even tried to program a macro (I'm not that procient in macros,
so something could be wrong...) but nothing worked. The best i could was
using the replace function and, in fact, in Excel it looked as if everything
was correct, i.e., i saw "3174742", . However, when I saved it to txt I got
this weird result: """3173471""". I could try to make the replacement in word
or notepad, but given the huge amount of files I'm using this would be to
cumbersome.
Does anyone has an idea how I could get around this?

Cheers,

Nuno
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Painter button problem Skip Bisconer Excel Discussion (Misc queries) 3 December 24th 04 06:05 PM
excel format cells/Number/Category: Number problem Matts Excel Discussion (Misc queries) 5 December 9th 04 09:47 PM
Problem with Date format from VBA code twig Excel Discussion (Misc queries) 3 December 7th 04 06:01 PM
cut and paste format problem Francis Hayes (The Excel Addict) Excel Discussion (Misc queries) 1 December 7th 04 02:23 PM
cell format problem kumarappans Excel Discussion (Misc queries) 3 November 26th 04 05:36 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"