Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When copying formula down it puts in a day of the week
When copying formula down (when there is no date yet) it puts in a day of the
week when it should acutally should be blank. here is the formula used TEXT(C8,"dddd") thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
When copying formula down it puts in a day of the week
0 equates to Saturday!
Try this: =IF(C8="","",TEXT(C8,"dddd")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Darts via OfficeKB.com" <u19990@uwe wrote in message news:6c8a4f3960c8e@uwe... When copying formula down (when there is no date yet) it puts in a day of the week when it should acutally should be blank. here is the formula used TEXT(C8,"dddd") thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
When copying formula down it puts in a day of the week
Thank you it worked out great!!!!!
RagDyer wrote: 0 equates to Saturday! Try this: =IF(C8="","",TEXT(C8,"dddd")) When copying formula down (when there is no date yet) it puts in a day of the [quoted text clipped - 3 lines] thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
When copying formula down it puts in a day of the week
Thank you for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Darts via OfficeKB.com" <u19990@uwe wrote in message news:6c8b04f9bf846@uwe... Thank you it worked out great!!!!! RagDyer wrote: 0 equates to Saturday! Try this: =IF(C8="","",TEXT(C8,"dddd")) When copying formula down (when there is no date yet) it puts in a day of the [quoted text clipped - 3 lines] thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula problem | Excel Worksheet Functions | |||
copying a formula | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions |