如果您在Word(Word)文档中使用大量数字并希望能够快速拼出它们,可以使用Word插件轻松完成此操作。
有一个Excel加载项版本,它的安装和工作方式与Word版本相同。这篇文章向您展示了如何安装和使用Word版本,但这些步骤可以应用于Excel版本。
两个版本都在Microsoft Word for Windows版本 2000、2002(XP)、2003、2007 和 2010 中进行了测试。
下载Popup SpellNumber for Word从
http://cpap.com.br/orlando/WordSpellNumberMore.asp?IdC=OMKtPlc。
下载用于 Excel 的Popup SpellNumber从(Popup SpellNumber )
http://cpap.com.br/orlando/ExcelSpellNumberMore.asp?IdC=OMKtPlc。
要安装Popup SpellNumber for Word,请双击您下载的.exe文件。
将显示一个介绍性对话框。单击(Click) 继续(Continue)。
将打开一个Word文档,其中包含插件的说明以及用于安装和卸载插件以及退出安装的按钮。单击(Click) 安装(Install)。
注意:(NOTE:)由于此文件允许您卸载加载项,因此我们建议您保留下载的.exe文件,以备将来决定卸载加载项时使用。
显示安装(Install)对话框。此对话框主要警告您需要提供管理权限才能安装加载项,并且将显示“用户帐户控制(User Account Control)”对话框。单击确定(OK)。
仅当您的用户帐户控制(User Account Control)设置设置为需要它的级别时,才会显示用户帐户控制(User Account Control)对话框。有关更改用户帐户控制(User Account Control)设置的更多信息,请参阅我们的帖子Windows – 如何配置 UAC(用户帐户控制) 。如有必要,单击是(Yes)继续。
显示安装为 COM 插件(Installation as COM Add-in)对话框。我们接受了安装的默认位置,并选择为所有用户安装它。单击继续(Continue)。
显示许可协议(License Agreement)。通读并单击“确定(OK)”继续。
安装完成后,将显示Installed with Success对话框。它告诉您如何在 Word中访问SpellNumber加载项。(SpellNumber)单击确定(OK)。
打开Word并键入一个十进制数,例如5.67。突出显示数字并右键单击选择。从弹出菜单中选择SpellNumber 。
将显示Word 的 SpellNumber(SpellNumber for Word)对话框。有几个选项供您自定义拼写数字。例如,使用字母大小写(Letter case)下拉列表指定拼写数字中的单词如何大写(如果有的话)。
使用单位单数(Unit singular)下拉列表指定单位的写出方式,具体取决于数字所代表的金额类型。要添加更多选项,请选择编辑建议(Edit suggestions)选项。
如果您选择了编辑建议(Edit suggestions)选项,则会显示编辑建议(Edit Suggestions)对话框。在编辑框中添加(Add)更多选项,用分号 ( ; ) 分隔每个选项。至少,需要“百分比(percent)”选项加上一个其他选项。
要访问其他选项,请单击更多选项(More options)按钮。
单位复数(Unit plural)下拉列表类似于单位单数(Unit singular)下拉列表,允许您指定输入金额的复数单位应如何写出。如果您想为 1000 写出“一千”,而不仅仅是“千”,请从“一千”(‘One thousand’)下拉列表中选择True 。
要在千位、十万位等之间插入逗号,请从千位逗号(Thousand comma)下拉列表中选择True 。
要将拼出的数字复制到剪贴板并关闭Word(SpellNumber for Word)的拼写数字对话框,请单击绿色的确定(OK)按钮。
您也可以在不关闭对话框的情况下将拼写出来的数字复制到剪贴板。为此,请单击复制到 Windows 剪贴板而不关闭(Copy to Windows clipboard without close)按钮。它看起来像一个典型的复制(Copy)按钮。
要将选项重置为其默认设置,请单击默认(Default)按钮。
红色方形按钮和它周围的四个绿色方形按钮可让您指定相对于Word文档中当前选择的位置,您要粘贴拼写数字。红色按钮将替换文档中的选定文本。绿色按钮代表所选文本周围的相应位置。
我们决定使用字母大小写(Letter case)下拉列表将标题大小写(Title Case)应用于我们的拼写数字,并通过单击红色按钮下方的绿色按钮将其粘贴到所选文本下方。
您也可以在不选择任何文本的情况下打开Word(SpellNumber for Word)的拼写数字对话框,然后将要拼写的数字直接输入到数字(Number)编辑框中。然后,您可以选择设置并如上所述复制号码。
您可以使用SpellNumber for Word将拼写数字复制到剪贴板,然后使用本文前面讨论的“不关闭复制到 Windows 剪贴板(Copy to Windows clipboard without close)”按钮将其粘贴到任何其他接受文本的Windows应用程序中。
请记住(Remember),这篇文章中的步骤也可以应用于Excel 的 SpellNumber(SpellNumber for Excel)。
Quickly Spell Out Numbers in Word and Excel
If you uѕe a lot of numbers in Word dоcuments and want to be ablе to qυiсkly spell them out, there is an add-in for Word that allows you to do this easily.
There is a version of this add-in for Excel that installs and works the same way as the version for Word. This post shows you how to install and use the version for Word, but the steps can be applied to the version for Excel.
Both versions were tested in Microsoft Word for Windows, versions 2000, 2002(XP), 2003, 2007, and 2010.
Download Popup SpellNumber for Word from
http://cpap.com.br/orlando/WordSpellNumberMore.asp?IdC=OMKtPlc.
Download Popup SpellNumber for Excel from
http://cpap.com.br/orlando/ExcelSpellNumberMore.asp?IdC=OMKtPlc.
To install Popup SpellNumber for Word, double-click on the .exe file you downloaded.
An introductory dialog box displays. Click Continue.
A Word document opens that contains a description of the add-in and buttons for installing and uninstalling the add-in and exiting the installation. Click Install.
NOTE: Since this file allows you to uninstall the add-in, we recommend you keep the .exe file you downloaded, in case you decide to uninstall the add-in at some future time.
The Install dialog box displays. This dialog box basically warns you that you need to provide administrative permission to install the add-in and that the User Account Control dialog box will display. Click OK.
The User Account Control dialog box displays, only if your User Account Control settings are set to a level that requires it. See our post, Windows – How to configure UAC (User Account Control), for more information about changing the User Account Control settings. Click Yes, if necessary, to continue.
The Installation as COM Add-in dialog box displays. We accepted the default location for the installation and chose to install it for all users. Click Continue.
The License Agreement displays. Read through it and click OK to continue.
Once the installation is finished, the Installed with Success dialog box displays. It tells you how to access the SpellNumber add-in within Word. Click OK.
Open Word and type a decimal number, such as 5.67. Highlight the number and right-click on the selection. Select SpellNumber from the popup menu.
The SpellNumber for Word dialog box displays. There are several options for you to customize the spelled-out number. For example, use the Letter case drop-down list to specify how the words in the spelled-out number will be capitalized, if at all.
Use the Unit singular drop-down list to specify how the unit will be written out, depending on what type of amount the number is meant to represent. To add more options, select the Edit suggestions option.
If you selected the Edit suggestions option, the Edit Suggestions dialog box displays. Add more options in the edit box, separating each option by a semicolon (;). At least, the “percent” option is required plus one other option.
To access additional options, click the More options button.
The Unit plural drop-down list is similar to the Unit singular drop-down list, allowing you to specify how the plural unit for the amount entered should be written out. If you want to write out “one thousand” for 1000, rather than just “thousand,” select True from the ‘One thousand’ drop-down list.
To insert commas between the thousands, hundred-thousands, etc., select True from the Thousand comma drop-down list.
To copy the spelled-out number to the clipboard and close the SpellNumber for Word dialog box, click the green OK button.
You can also copy the spelled-out number to the clipboard without closing the dialog box. To do this, click the Copy to Windows clipboard without close button. It looks like a typical Copy button.
To reset the options to their default settings, click the Default button.
The red square button and the four green square buttons around it allow you to specify where, in relation to the current selection in your Word document, you want to paste the spelled-out number. The red button will replace the selected text in your document. The green buttons represent the respective positions around the selected text.
We decided to apply Title Case to our spelled-out number using the Letter case drop-down list and paste it below the selected text by clicking the green button below the red button.
You can also open the SpellNumber for Word dialog box without having any text selected and type the number you want to spell out directly into the Number edit box. Then, you can choose settings and copy the number as described above.
You can use SpellNumber for Word to copy a spelled-out number to the clipboard and paste it into any other Windows application that accepts text using the Copy to Windows clipboard without close button discussed earlier in this post.
Remember, the steps in this post can be applied to SpellNumber for Excel, also.