Question about Microsoft Office Standard for PC

1 Answer

Convertion of amount figure to words

Dont know how to program to VBA on how to convert amount to words

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 117 Answers

Go here:

http://xl.barasch.com/cCo11432.htm

The function was originally from MS themselves.

Posted on Oct 21, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I want to convert figure to words in microsoft excel


You have to do some programming in VBA to pull this one off. Microsoft has everything you need in this article.

http://support.microsoft.com/kb/213360

If you have trouble with this, get back to me and I will do it and send you an excel file. I just need to know what version of excel you want.

Mar 04, 2011 | Computers & Internet

Tip

How to Convert PDF to Word for Free?


As a universal file format out there, PDF is considered ideal for uploading, downloading, and publishing documents over the internet. But as it is no easy to edit or change the text in PDF format, sometimes you may need to convert PDF to other format file if you make some changes to your PDF files?<br /><br /> Recently I find many people wonder <a href="http://www.nemopdf.com/knowledge/how-to-convert-pdf-to-word.html">how to convert PDF to word</a>, but not willing to pay for Adobe Acrobat. So, here is the question, how to convert PDF to Word without Adobe Acrobat? With respect to this problem, I believe you can find many free online PDF converters. It's a really good option if your PDF files are not important. However if you want to convert some confidential PDF files to Word, it isn't an ideal choice without doubt.<br /> In that situation, my suggestion is to get an efficient PDF to Word converter. Aside from 100% free online PDF convert websites, there're many programs allowing you to convert PDF to Word for free. Here I will introduce a free PDF to Word convert software and teach you how to covert PDF to Word by using this program.<br /> <br />Nemo PDF To Word is completely free Word to PDF convert software. By using it, you can convert your PDF files to well-formatted and editable Word/RTF in seconds. After conversion, the original text, images, tables, columns, graphics and other formats are well saved in the generated files. It supports batch conversion and partial conversion, greatly saving your time.<br /> <br />As for how to convert PDF to word by using free Nemo PDF to Word, just follow the steps below, you can know how to <a href="http://www.nemopdf.com/knowledge/how-to-convert-pdf-to-word.html">convert PDF to Word for free</a>.<br /> <br />Step 1. Import PDF flies<br /> Click Add Files button to load your target PDF files into the program. The file information like file size and pages will be listed once imported.<br /> <br />Step 2. Make settings<br /> Under Output, you can specify the page range, select Word documents as output file format and output path.<br /> <br />Step 3. Covert PDF files to Word<br /> Click the Convert button to start converting your PDF files to Word.<br /> <br />When the conversion completes, a dialog box will pop up. You can view the generated Word files directly by clicking Open File or Open Folder on it.<br /> <br />Worth Noting:<br /> 1. During conversion, the Convert button will be changed to Stop button. You can stop converting anytime by clicking the Stop button.<br /> <br />2. If your PDF files are encrypted, it will pop up a dialog box for password immediately after importing it. You can load and convert the secured file normally after inputting the correct password.<br /> <br />3. If you want to convert the generated Word documents to PDF, Nemo PDF Converter will do you a favor.

on Aug 18, 2011 | Computers & Internet

Tip

How to Convert Word to PDF?


There are two ways to convert Word to PDF, One from Tenorshare PDF Converter program, the other from Microsoft Word directly for while installing Tenorshare PDF Converter on your PC, it is integrated in the Microsoft Word. Opening any of the documents, you will see a button named "Tenorshare PDF Converter" in your toolbar. Just click it to start the program for conversion.

Here we will discuss how to convert Word to PDF with Tenorshare PDF Converter.

Step 1: Import Word files
Download Tenorshare PDF Converter and install it on your PC. Run the program, you can see the following interface. Select "Convert to PDF", Click "Add Files" button to add Word files you want to convert. Tenorshare PDF Converter allows you to add unlimited files one time for conversion.
maggiena_5.gif

Step 2: Specify output folder
Click "Browse" to locate your output folder for your destination files. And you can customize the output features of your PDF files with "Advanced Options"
maggiena_9.gif


In "Advanced Options", you can set the description, security, etc. Tenorshare PDF Converter helps you save your PDF files with
40-bit or 128-bit encryption algorithms, and you can set password for the file owner and users. Truly ensure the PDF files security.

Step 3: Convert Word files with one click
Click "Convert" button to start conversion. After successfully completed, the finish dialogue window will appear. Click "Open File" button to view the converted file or click "Close" button to close the screen.
maggiena_7.gif

on Feb 25, 2011 | Computers & Internet

1 Answer

Need Formula


TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

4 Answers

CONVERT FIGURE INTO WORD


i want to convert the figure / number in word

eg. 1,000 = ONE THOUSAND

Aug 22, 2008 | Computers & Internet

1 Answer

Excel password is protected....... but not i don't know that password,,,,,,, so password are remove if i see that password


Excel Password Remover 2008

Excel Password Remover
Instructions
FAQ
Disclaimer
Excel Password Remover PRO

--------------------------------------------------------------------------------
Recommended links:
Password recovery software (Word, Excel, Outlook, Exchange, Visual Basic modules, Access, Winzip, Lotus 1-2-3, Lotus Organizer, Lotus Wordpro, Backup, Project, FileMaker, Schedule+, Money, Paradox, Act!, Mail, Windows NT)
Instant password recovery (Instant online recovery service for password protected MS Word and Excel files. Free online preview of encrypted file content. )
Visual Basic Password (Instant recovery of VBA-passwords in Office programs)
Excel add-in decompiler (Converts Excel add-ins into normal workbooks)

Have you ever forgotten your Excel workbook or sheet password?
Here you can download a FREE Excel add-in that removes/cracks sheet and workbook password protection in Excel®.
NB! This program can't remove file protection, i.e. if you are unable to open the file, this program won't help you. You could try Excel Key to remove file protection. If you need to crack the VBA-password try this one.
This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP and 2003).
This program will remove passwords of any length, also passwords containing special characters.
Download here: password

Feb 23, 2008 | Computers & Internet

5 Answers

Eager To Learning MS Access


The easiest and fastest way to learn the basics of any of the main office programs is with multimedia tutorials. Ranging 5-10 times faster than text. More can be learned in this way in a shorter time.
In regards to VBA, if you only want to work with macros and scripts within an application, a minimal knowlege is all that is necessary. If you are wanting to use VBA across applications, you will need a little more depth of knowlege (at least in my case) is needed. May I suggest Microsoft's 'inside out' series of books. It looks intimidating but you only need the section you are studying.
There is something special about getting tutorials and learning information from the actual program manufacturer. They are the authority and free.
Okay, my suggestion is to first go to Microsofts website and view the tutorials available for your application: MS Office tutorials
Then, if you find your thirst for knowledge unquenched:
4db359c.jpg
  • Third party online tutorials are often quite good. But often the depth knowledge like VBA will turn into a 'tips and tricks' rather than the foundation needed.
  • Get some of the multimedia learning, all it takes is a few 20 minute segments. Titles like Mastering Access 2003 by Magic Media, includes VBA.
Learning some of these applications can be very daunting. It is estimated that your typical user will use only around 10% of the programs capabilities. And they keep adding capabilities! Anyway start easy and work your way up to the complexity you want.
For the other users that have similiar problems, the real answer is to learn the above. But to convert numbers to words you need to redefine the field as text, and enter numbers.
And if you are setting up a search criteria for multiple text boxes using IF condition, it depends on what you are comparing. If you are comparing to a set quantity it would look something like this: IF field/text box = "Fixya" THEN performed action. Endif. If you are comparing two or more text boxes to each other it may look something like this: IF field/textboxA = fieldtextboxB or fieldtextboxC THEN action Else action. Endif

Hope this helps!
Ted

Dec 30, 2007 | Microsoft Office Access 2003 (077-02871)...

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

47 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...