News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Convert Decimal to yyy...

Power Automate - Building Flows

Answered

Convert Decimal to yyyy-MM-dd format from Excel

Like (0) Share

Report

Report

Posted on 17 Dec 2022 11:26:54 by ganeshn07

20

I have a two columns in Excel which are giving date in decimal format. Kindly help me to get it in the date format.

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-liwei-msft on 19 Dec 2022 at 08:34:48

Like (0)

Report

Re: Convert Decimal to yyyy-MM-dd format from Excel

Hi @ganeshn07

The reason for this problem may be that your date column is in Text format.
You can try to convert it to Date format.

Best Regards,

Levi
Amit_Sharma 1,569 Super User 2024 Season 1 on 18 Dec 2022 at 06:09:01

Like (0)

Report

Re: Convert Decimal to yyyy-MM-dd format from Excel

Hi @ganeshn07,

Could You Confirm Me What Is Date, Month and Year in Selected Decimal Value 44882.8367

Helpful resources

News and Announcements

🌸You're Invited: Community Spring Festival Awards Celebration 🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,776 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,093 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans