Thread: When copying formula down it puts in a day of the week
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darts via OfficeKB.com Darts via OfficeKB.com is offline
external usenet poster
  
Posts: 29
Default 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

Reply With QuoteReply With Quote