Help with dataset

New Contributor

Hi !

I just wanted to begin by saying that I'm very new to Excel so I'm still learning the ropes ! 


I've been trying to do some work with a data set and when I open it in Excel everything seems fine at first but when I click the 'enable editing' button some of the values disappear. I've attached two screenshots of how it looks before and after clicking the button (everything under day of week/month/year disappears). 

Any advice on how I can stop this from happening ? 


Thank you ! 

3 Replies


Which formulae do you have in columns in question? Perhaps you may share the file with first few rows instead of screenshot.

@Sergei BaklanHello !


I've attached the file to this message if it helps.

The TEXT() formulas contain format strings appropriate for English language settings. You have to adjust the format strings to your language setting.