If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Paste as Text option is missing...help
Look under PasteSpecial and click the Value option.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ron" wrote in message om... I am using Excel 2000 (9.0.6926 SP-3) and I can't find the "Paste as Text" option to save my life. It's been a while since I have tried to use the option, but it should be under "paste special" correct? Anyone? |
#2
|
|||
|
|||
Paste as Text option is missing...help
Ron
If you are pasting text from another application, you would hit Paste Special where you would be given options of "Unicode Text" or "Text" If pasting from within Excel, follow Bob's advice. Gord Dibben Excel MVP On 21 Jul 2004 09:04:08 -0700, (ron) wrote: I am using Excel 2000 (9.0.6926 SP-3) and I can't find the "Paste as Text" option to save my life. It's been a while since I have tried to use the option, but it should be under "paste special" correct? Anyone? |
#3
|
|||
|
|||
Paste as Text option is missing...help
First, I think you've got a mistake in your post.
That 230.00 is missing a trailing 0 (and the date has an extra leading 0). I think I'd do the special formatting right before I built that long string. But I think I'd format the cells to match what was required--just so things matched. but if you have real numbers in the Account, check#, amount fields and a real date in the date field, I'd just build my own string: My formula would look like this with the data in A11, =TEXT(A1,REPT("0",11)) & TEXT(B1,REPT("0",6)) &TEXT(C1*100,REPT("0",12)) & TEXT(D1,"mmddyy") I think you'll have to adjust the number of 0's in each field to match your spec. Build your working formula and copy it down your helper column. Then copy that column and paste into Notepad, save your text file from there and send that. 000104330000005190000000023000702104 Account Check#Amount Date ron wrote: I need to be able to take the value 230.00 and paste it into a cell as 230.00 text. If I paste it as "values", then the pasted cell will read 230, not 230.00 that I need. Also, I can format a cell so that typing "519", will display as "00000519" How can I copy the 00000519 as text into another cell...keeping all the 0's Here is why I am asking: When our company cuts checks, we must submit a text file to the bank that includes the follwing information: Account Number, Check Number, Amount, Date As an example: Account number 00010433000 Checks - 000519 for 230.00, 000520 for 1,000.00 Date 7/21/04 The txt file that I would submit would look like this: 000104330000005190000000023000702104 000104330000005200000000100000702104 Break up is 00010433000 000519 000000002300 0702104 Account Check# Amount Date Since the Account number is constant and the date will be the same for each check run, the only 2 areas of concern are check number and amount. The idea is to export the check run summary to excel - copy the numbers, paste them as text, then use the CONCATENATE command to join all of the text. Any suggestionas? TIA Ron Gord Dibben gorddibbATshawDOTca wrote in message . .. Ron If you are pasting text from another application, you would hit Paste Special where you would be given options of "Unicode Text" or "Text" If pasting from within Excel, follow Bob's advice. Gord Dibben Excel MVP On 21 Jul 2004 09:04:08 -0700, (ron) wrote: I am using Excel 2000 (9.0.6926 SP-3) and I can't find the "Paste as Text" option to save my life. It's been a while since I have tried to use the option, but it should be under "paste special" correct? Anyone? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
text is missing after I convert to pdf | Blanca | Powerpoint | 1 | June 11th, 2004 09:36 PM |
Print calendar with all day events missing white text on black background since moving from 2000 | Nickb1 | General Discussion | 0 | June 7th, 2004 03:46 PM |
Edit same text in multiple locations | Angelo | Formatting Long Documents | 3 | May 19th, 2004 03:43 PM |
Option Group values converted to Text String values in reports | Fons Ponsioen | Setting Up & Running Reports | 1 | May 18th, 2004 10:50 PM |
News...Icon Missing from Command Option, where is it? | Lynn | Installation & Setup | 1 | May 6th, 2004 08:26 PM |