For Joey2004 et al. From OP: Re Appending Question
Hello,
Thanks so much for help; really appreciate it. Not sure how to implement what you are suggesting: Regarding the Custom Format suggestion: O"MHz" What is the O ? Is this a letter or number ? What do I put for it; could you give me an example using my data, please ? Hate to appear dumber with this than I am, but will blame it on "old-age" now. Much thanks, Bob ------------------------------------- On 2/28/2013 7:38 PM, joeu2004 wrote: "Bob" wrote: Have a very long column of numbers: [....] I want to add the following text, MHz, to each, e.g. 4MHz 7MHz 9MHz etc. Instead of making the cell text per se, I would suggest that you simply use a Custom format, e.g. 0"MHz" . Thus, the cell retains in numeric value, but MHz appears in the displayed value. Select the cells to change their format. Or use the Format Painter tool. |
For Joey2004 et al. From OP: Re Appending Question
Hi Bob,
Am Fri, 01 Mar 2013 12:31:41 -0500 schrieb Bob: What is the O ? Is this a letter or number ? What do I put for it; could you give me an example using my data, please ? if you only have integers, then it is a zero If you have decimals, then try 0,00 "MHz" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
For Claus et al From OP: Re Appending Question
Hi Claus,
Much thanks. Might I ask one more, please: In one of my columns, Column D, I have, e.g., a b a a f g a w I want to Delete any and all rows that have an "a" in Column D. I thought I could use the Filter Command, but this doesn't seem appropriate. What's the best way, please ? Thanks again, Bob ----------------------------------------------------------------------------------- On 3/1/2013 12:39 PM, Claus Busch wrote: Hi Bob, Am Fri, 01 Mar 2013 12:31:41 -0500 schrieb Bob: What is the O ? Is this a letter or number ? What do I put for it; could you give me an example using my data, please ? if you only have integers, then it is a zero If you have decimals, then try 0,00 "MHz" Regards Claus Busch |
For Claus et al From OP: Re Appending Question
Hi Bob,
Am Fri, 01 Mar 2013 13:04:12 -0500 schrieb Bob: In one of my columns, Column D, I have, e.g., a b a a f g a w I want to Delete any and all rows that have an "a" in Column D. to filter for "a" is the best way. Select the visible rows and delete them. Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
All times are GMT +1. The time now is 06:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com