Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id : dKXHo9mlVe1lR8e+/LWSW8
Power Platform Community / Forums / Power Automate - Building Flows / Convert Decimal to yyy...
Power Automate - Building Flows
Answered

Convert Decimal to yyyy-MM-dd format from Excel

Like (0) ShareShare
ReportReport
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.

 

ganeshn07_0-1671276389438.png

 

  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on 19 Dec 2022 at 08:34:48
    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.

     

    vliweimsft_0-1671438866079.png

     

    vliweimsft_1-1671438866080.png

     

    vliweimsft_2-1671438866081.png

     

    Best Regards,

    Levi

  • Amit_Sharma Profile Picture
    Amit_Sharma 1,569 Super User 2024 Season 1 on 18 Dec 2022 at 06:09:01
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 276 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 234 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 210

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans