Populating a second worksheet
I know it's possible to copy absolute values from one page to another but I'm
trying to copy text and I'm getting '0' in the cells that are blank. How can I remedy this? Do I need to format cells? If so, on one sheet or both? |
Populating a second worksheet
You could always suppress zeroes, ToolsOptionsViewZero Values in the
windows Options segment. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tealady" wrote in message ... I know it's possible to copy absolute values from one page to another but I'm trying to copy text and I'm getting '0' in the cells that are blank. How can I remedy this? Do I need to format cells? If so, on one sheet or both? |
Populating a second worksheet
Thank you, Bob! Thank you! That's what I needed. I didn't realize that was
available. This really is a great site. "Bob Phillips" wrote: You could always suppress zeroes, ToolsOptionsViewZero Values in the windows Options segment. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tealady" wrote in message ... I know it's possible to copy absolute values from one page to another but I'm trying to copy text and I'm getting '0' in the cells that are blank. How can I remedy this? Do I need to format cells? If so, on one sheet or both? |
Populating a second worksheet
You can also slect all the cells you just pasted in to, press the F5 key,
click on the special button, check Constants and make sure only Numbers is selected below that. Click on OK, and you'll find that all the zeros are selected (be careful if you also copied numbers - they'll be selected, too). Then press the delete key to wipe them all out. "Tealady" wrote: I know it's possible to copy absolute values from one page to another but I'm trying to copy text and I'm getting '0' in the cells that are blank. How can I remedy this? Do I need to format cells? If so, on one sheet or both? |
Populating a second worksheet
That works in MS Office Excel 2003, but I cannot find anything similar in MS
Office Excel 2007, which my company recently installed. Any ideas? "Bob Phillips" wrote: You could always suppress zeroes, ToolsOptionsViewZero Values in the windows Options segment. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tealady" wrote in message ... I know it's possible to copy absolute values from one page to another but I'm trying to copy text and I'm getting '0' in the cells that are blank. How can I remedy this? Do I need to format cells? If so, on one sheet or both? |
All times are GMT +1. The time now is 09:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com