Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying a cell that has been formatted to cell with conditionals
My cell D7 is perfect.
I had to clear the cell D7,because above it were dates (don't ask me why,) D7 assumed I wanted a format date or date/number in D7 instead of the difference. So I fcleared it and format cell general then D7 formula =D6-D5 (perfect) Added 3 conditionals (perfect color shadeing) If I try and copy D7 tp E7:N7. It reverts back to dates/or date3's rathr than a general cell that subtacts the two dates. Is there a way to make a true copy of D7, with general cell, formula + the 3 conditionals without ahving to do each on. ;ie d5 is 01/01/09 d6 is 01/10/09 d7 is 9 it is a formatted general cell, not a date, has 6-5 and 3 conditionals Can I copy all that to E7:N7? Thanks once again? so |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying a cell that has been formatted to cell with conditionals
Mark;215562 Wrote: My cell D7 is perfect. I had to clear the cell D7,because above it were dates (don't ask me why,) D7 assumed I wanted a format date or date/number in D7 instead of the difference. So I fcleared it and format cell general then D7 formula =D6-D5 (perfect) Added 3 conditionals (perfect color shadeing) If I try and copy D7 tp E7:N7. It reverts back to dates/or date3's rathr than a general cell that subtacts the two dates. Is there a way to make a true copy of D7, with general cell, formula + the 3 conditionals without ahving to do each on. ;ie d5 is 01/01/09 d6 is 01/10/09 d7 is 9 it is a formatted general cell, not a date, has 6-5 and 3 conditionals Can I copy all that to E7:N7? Thanks once again? so Does Copy - Paste Special - Check " value and number formats" - OK answer your question? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59201 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying a cell that has been formatted to cell with conditionals
Yes, and I found I was doing a simple copy wrong.. Thank you Pecoflyer
too much today.. just too much.. thanks "Mark" wrote: My cell D7 is perfect. I had to clear the cell D7,because above it were dates (don't ask me why,) D7 assumed I wanted a format date or date/number in D7 instead of the difference. So I fcleared it and format cell general then D7 formula =D6-D5 (perfect) Added 3 conditionals (perfect color shadeing) If I try and copy D7 tp E7:N7. It reverts back to dates/or date3's rathr than a general cell that subtacts the two dates. Is there a way to make a true copy of D7, with general cell, formula + the 3 conditionals without ahving to do each on. ;ie d5 is 01/01/09 d6 is 01/10/09 d7 is 9 it is a formatted general cell, not a date, has 6-5 and 3 conditionals Can I copy all that to E7:N7? Thanks once again? so |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying a cell that has been formatted to cell with conditionals
Mark;216114 Wrote: Yes, and I found I was doing a simple copy wrong.. Thank you Pecoflyer too much today.. just too much.. thanks "Mark" wrote: My cell D7 is perfect. I had to clear the cell D7,because above it were dates (don't ask me why,) D7 assumed I wanted a format date or date/number in D7 instead of the difference. So I fcleared it and format cell general then D7 formula =D6-D5 (perfect) Added 3 conditionals (perfect color shadeing) If I try and copy D7 tp E7:N7. It reverts back to dates/or date3's rathr than a general cell that subtacts the two dates. Is there a way to make a true copy of D7, with general cell, formula + the 3 conditionals without ahving to do each on. ;ie d5 is 01/01/09 d6 is 01/10/09 d7 is 9 it is a formatted general cell, not a date, has 6-5 and 3 conditionals Can I copy all that to E7:N7? Thanks once again? so Most welcome -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59201 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do I get this ###### instead of 11:00 p.m. in formatted cell? | New Users to Excel | |||
How do I find out how a cell is formatted | Excel Discussion (Misc queries) | |||
Formatted Cell | Excel Discussion (Misc queries) | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |