This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I am trying to use the SpellNumber function in Excel where we use some macros in CargoWise system to retrieve data of the fields. Therefore, the values in the cells are shown only after generating the particular report.
In there I need to convert one such cell value (Number) to words. The cell value is CIF Total and it is the sum of the cells FOB Amount+ Freight + Insurance+ Other. Their values are also retrieved using macros in the system and formulas.
Therefore, when the SpellNumber function is used, it shows an error as #Name?, Is there any other way that could be used rather than the cell value.
I tried the SpellNumber option for formulas where SpellNumber(Cell1 +Cell2), even then as the cell are having macros the #Name? error is coming.
Could anyone please help me on this matter.
Thank you,
Hashini Fernando
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
The #NAME? error suggests that the SpellNumber function is missing. If it was available, it would return #VALUE! instead.
Apologies, I corrected it and is there any way this could be corrected
Cell AO9769 contains #VALUE! so SpellNumber results in an error too.
If you want to suppress this error, change the formula to
=IFERROR(SpellNumber(AO9769),"")