Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-22-2013, 11:29 PM
BobBridges's Avatar
BobBridges BobBridges is offline Concatenate function for displaying numbers in words Windows 7 64bit Concatenate function for displaying numbers in words Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Pecoflyer, on a hunch I did a little googling. As you might expect, SpellNumber is a function that's supposed to turn a value such as 39 into a character string "thirty-nine".

From what I see out there, it's claimed it comes with Excel 2010 and also that it has to be written in VBA. I don't know which is correct; I've never had need of such a thing and never had to look it up. Anyone else know the real story?

Officeboy, when Excel says "#NAME?", it usually means you misspelled a function name. In this case I'm betting SpellNumber simply doesn't exist, at least not where Excel can find it. If it's part of an Excel Add-In, you need to add it in; either that or you just need to write the function yourself, or go fetch the code for it from the web somewhere.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate function for displaying numbers in words Using the sum function to display number as well as words in a single cell officeboy09 Excel 8 10-30-2013 05:38 AM
Words in my document were converted to numbers???? MikeD23 Word 1 08-26-2012 11:09 AM
Concatenate function for displaying numbers in words can't activate remove page numbers function gsjackson Word 5 01-16-2012 05:30 PM
Numbers in Words janak Excel 2 12-19-2010 08:53 PM
Concatenate function for displaying numbers in words displaying start and finish times as absolute numbers instead of dates benson.wallace Project 2 12-05-2010 07:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft