web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Excel calculation whil...
Microsoft Dynamics NAV (Archived)

Excel calculation while importing

(0) ShareShare
ReportReport
Posted on by NavTech 2,390

I am importing a excel into Nav using excel buffer. I want to use excel calculation formula like LEN ,MID on some fields of excel.I want to apply the formula in some excel cell and import the value of cell in Nav.

*This post is locked for comments

I have the same question (0)
  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    What kind of formula you want to use?

    Best Regards,

    MMV

  • NavTech Profile Picture
    NavTech 2,390 on at

    Excel formule for example   =MID(A3,1,25),=LEN(A3).

    I am trying to make formula string but dont know where to pass it

  • mmv Profile Picture
    mmv 11,471 on at

    Why don't you use the same formula in NAV and calculate the values?

  • NavTech Profile Picture
    NavTech 2,390 on at

    in clients functionality they have some fields for enter excel cell numbers like A1, B4,

    Based on these cell value I have to prepare a excel formula( LEN(A1) or MID(B4,2,6) ) and apply.

  • mmv Profile Picture
    mmv 11,471 on at

    Have you checked the below?

    www.mibuso.com/.../viewtopic.php;t=1067

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at

    Hi NavTech,

    System imports value of Excel Cell (result of formula) by default. May be the formula cells are formatted as text. Try to format them as general, reupdate the formula. Besides, paste value can be helpful!

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans