Posting excel doc to Teams and losing formatting

Copper Contributor

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  :) 

Mel_Dyson_0-1646382803288.png

Mel_Dyson_1-1646383062830.png

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

Mel_Dyson_2-1646383158297.png

 

2 Replies

@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.

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