Forum Discussion

Mel_Dyson's avatar
Mel_Dyson
Copper Contributor
Mar 04, 2022

Posting excel doc to Teams and losing formatting

So I have a calendar made in excel listing task by day - it looks perfect. When I post it to Teams in Microsoft the dates show up as hashtags?? I've tried lots of things and I just cant get the dates to show as they do in excel 23 March (as an example). The dates were calculated as a formula, which I have since removed. I removed the formula, that formed the dates, thinking that was the issue. No luck. Below is a snip of the document in Teams and another snip of the excel doc. Thank you for helping me think this trough  🙂 

I just noticed 11/2/1900 sitting behind 2-Feb date?

 

excel
office 365

2 Replies

  • resli-b's avatar
    resli-b
    Copper Contributor
    Mar 30, 2022

    Mel_Dyson Did you ever work out how to get rid of the ### and get your dates back? I am having the same issue - dates/formatting perfect in desktop but dates are replaced with ##### when opened via Teams. Any suggestions? I'm a bit of a novice.

    • Mel_from_the_Territory's avatar
      Mel_from_the_Territory
      Copper Contributor
      Mar 30, 2022
      Yes, I removed the formating (code) behind the dates. The document I was using was a template that automated the date, the formula was written by another person. I googled how to do this, was simple to do find instructions online, and there are a number of methods to do this.

      If you don't have code behind your data (that isn't holding its format when uploaded in Teams), it might be as simple as your margins being to small. These can easily be adjusted by hovering and drag with the mouse to make the sells larger.

      My issue was both 🙂
      Good Luck

Resources