• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formatting issue when adding two text cells together

TheBigCountry

New Member
I have a spreadsheet where I have enter a date in one cell, and then it autofills the rest of the sheet by using B1+1, B2+1, etc.

At the beginning of each weekly group, I have a summary saying Week: and then I've written a formula =(B42&"-"&B47) so that it shows Week: 12/22/15-12/27/15 (as an example)

However, in the cell where I have my week (in the example above 12/22/15-12/27/15, the result is showing up as 42360-42365 instead of dates. I know this is related to a formatting issue but can't figure out how to fix it.
 

Attachments

  • example.xlsx
    19.5 KB · Views: 4
Back
Top