Home

Spell out issue?

%3CLINGO-SUB%20id%3D%22lingo-sub-831637%22%20slang%3D%22en-US%22%3ESpell%20out%20issue%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831637%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20estimate%20sheet%20that%20has%20a%20cell%20that%20has%20the%20code%20%3DSpellNumber(J24)%20in%20one%20of%20the%20cells.%20%26nbsp%3BSpells%20out%20the%20dollar%20amount%20of%20that%20number.%20%26nbsp%3BSheet%20works%20fine.%20%26nbsp%3BOpened%20the%20sheet%20to%20make%20some%20adjustments%2C%20and%20now%20it%20will%20not%20spell%20out%20the%20dollar%20amount.%20%26nbsp%3B%20Noting%20I%20did%20should%20effect%20that%20coding%3F%20%26nbsp%3BI%20am%20using%20Office%20365.%20%26nbsp%3BThe%20error%20I%20am%20getting%20is%20%23NAME%3F.%20%26nbsp%3B%20Tried%20to%20save%20the%20sheet%20in%20a%20Macro-Enabled%20and%20Standard%2C%20noting%20seems%20to%20matter.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-831637%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831721%22%20slang%3D%22en-US%22%3ERe%3A%20Spell%20out%20issue%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380356%22%20target%3D%22_blank%22%3E%40Budman36%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%23NAME%3F%20error%20means%20Excel%20is%20not%20familiar%20with%20the%20function%20you%20are%20using.%20Maybe%20that%20UDF%20is%20not%20available%20now%20in%20your%20file.%3C%2FP%3E%3CP%3EWhile%20your%20file%20is%20open%2C%20press%20Alt%2BF11%20to%20open%20the%20VB%20Editor%20and%20check%20in%20the%20project%20explorer%20pane%20on%20the%20left%20to%20see%20if%20there%20is%20a%20Module%20inserted%20like%20Module1%20etc.%20Double%20click%20that%20module%20and%20see%20if%20the%20code%20window%20contains%20the%20function%20you%20are%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20don't%20find%20that%20function%20in%20there%2C%20that%20means%20you%20have%20lost%20it%20and%20you%20will%20need%20to%20place%20it%20again%20to%20make%20it%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834378%22%20slang%3D%22en-US%22%3ERe%3A%20Spell%20out%20issue%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20was%20the%20issue.%20%26nbsp%3BNot%20sure%20how%20it%20was%20deleted%2C%20but%20it's%20back%20and%20works%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834393%22%20slang%3D%22en-US%22%3ERe%3A%20Spell%20out%20issue%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380356%22%20target%3D%22_blank%22%3E%40Budman36%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%20Glad%20I%20could%20help.%3C%2FP%3E%3CP%3EPlease%20take%20a%20minute%20to%20close%20your%20question%20by%20accepting%20the%20post%20as%20an%20Answer%20which%20helped%20you%20to%20resolve%20the%20issue%20you%20were%20having.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Budman36
Contributor

I have an estimate sheet that has a cell that has the code =SpellNumber(J24) in one of the cells.  Spells out the dollar amount of that number.  Sheet works fine.  Opened the sheet to make some adjustments, and now it will not spell out the dollar amount.   Noting I did should effect that coding?  I am using Office 365.  The error I am getting is #NAME?.   Tried to save the sheet in a Macro-Enabled and Standard, noting seems to matter. 

3 Replies

@Budman36 

#NAME? error means Excel is not familiar with the function you are using. Maybe that UDF is not available now in your file.

While your file is open, press Alt+F11 to open the VB Editor and check in the project explorer pane on the left to see if there is a Module inserted like Module1 etc. Double click that module and see if the code window contains the function you are using.

 

If you don't find that function in there, that means you have lost it and you will need to place it again to make it work.

@Subodh_Tiwari_sktneer 

 

That was the issue.  Not sure how it was deleted, but it's back and works now.

 

Thanks for the help.

 

@Budman36 

You're welcome! Glad I could help.

Please take a minute to close your question by accepting the post as an Answer which helped you to resolve the issue you were having.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies