Data Refresh - Formulas

[monaug5]

Hello,


I have the data connection to an excel sheet on a sharepoint site which is pull out the data every time I refresh the data in my column F which: =TEXT([@[Please enter the date of inspection]],"mmmm yy")

However, when I refresh the data using the "Refresh" tab the months shown in column F: June 2022 does not load anymore and instead I have the number 44713 in the column?

I also lose the formulas in other columns after the refreshing of data. How do I fix this?

 

[James006]

Hi,
Have you tried to format your number as a date .... to get 01 06 2022

 

[monaug5]

Thanks very much. Got it solved!

 

[James006]

You are welcome