Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |