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