Question about Microsoft Windows XP Home Edition

3 Answers

CONVERSION OF NUMERICAL VALUE INTO TEXT IN M.S. EXCEL

HOW DO I CONVERT NUMBERS INTO TEXT.? OR HOW TO INSTALL THAI LANGUAGE IN MY PC HAVING WINDOWS 2003

Posted by on

  • J Kelsey May 11, 2010

    What software are you using?

×

3 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How to convert Numbers to Text Example Rs1000/- to convert it One thousand

Posted on Dec 15, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 189 Answers

To convert a numbers to text, by just typing an apostrophe symbol before the number.
thnaks

Posted on Nov 18, 2008

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 3 Answers

To convert numbers into text, just add an apostrophe ' to the left of the number. When you press enter, the apostrophe will no appear, but the number will have the atrtibutes of text

Posted on Nov 18, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

The keyboard types thai. how to convert to english?


Hi vibhakawatra,

Your language settings have been set to Thai thats why the keyboard types Thai. However you can change it by following the steps below.
NOTE: The pictures shown below are in reference to Windows Vista. There will be little variations according to the Operating Systems.

1) Click Start and Select Control Panel.

arun_zac_4.jpg

2) Double click Regional and languages Options.

arun_zac_5.jpg

3) A window will pop up. In the window select the 'Keyboard and Languages Tab'.

arun_zac_6.jpg

4) Click on the 'Change Languages' button.

arun_zac_7.jpg

5) In the General Tab, Select the 'Add' Button to add languages.

6) Now, from the list of languages find and select 'English (US)' and click OK.

arun_zac_8.jpg

6) The current window closes and returns to the previous window. First click 'Apply' and then click 'OK'

7) Then again click 'OK'.

Your done. You might have to restart your computer for the changes to take effect.

Hope this solves your problem. If this information was helpful please rate this solution.

Thank you for using fixya.

Arun Zac

Nov 24, 2010 | Acer Operating Systems

4 Answers

Limewire pro 5.5.14 license key


Get it from Your Product Service Care Or Search it through Online.

Oct 04, 2010 | Operating Systems

2 Answers

Convert excel sheet 2003 into 2007 excel how it can be done


You'll need to download and install microsoft's compatibility pack from

:-http://office.microsoft.com/en-us/products/HA101686761033.aspx

Jul 04, 2010 | Operating Systems

1 Answer

How to convert a numeric value into English words in Excel in indian style


its function in the office suite called spell number, i forgot it even was there, you may have to switch some of the functions to have it convert to indian and your local dialect that you want to convert it to.

follow the link attached
http://support.microsoft.com/kb/213360

Good luck
Mel

Jun 11, 2010 | Microsoft Windows XP Home Edition

1 Answer

Convert numbers to text in excell


  1. Start Microsoft Excel.
  2. Press ALT+F11 to start the Visual Basic Editor.
  3. On the Insert menu, click Module.
  4. Type the following code into the module sheet. Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none. DecimalPlace = InStr(MyNumber, ".") ' Convert cents and set MyNumber to dollar amount. If DecimalPlace > 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2)) MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber <> "" Temp = GetHundreds(Right(MyNumber, 3)) If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars If Len(MyNumber) > 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop Select Case Dollars Case "" Dollars = "No Dollars" Case "One" Dollars = "One Dollar" Case Else Dollars = Dollars & " Dollars" End Select Select Case Cents Case "" Cents = " and No Cents" Case "One" Cents = " and One Cent" Case Else Cents = " and " & Cents & " Cents" End Select SpellNumber = Dollars & Cents End Function ' Converts a number from 100-999 into text Function GetHundreds(ByVal MyNumber) Dim Result As String If Val(MyNumber) = 0 Then Exit Function MyNumber = Right("000" & MyNumber, 3) ' Convert the hundreds place. If Mid(MyNumber, 1, 1) <> "0" Then Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred " End If ' Convert the tens and ones place. If Mid(MyNumber, 2, 1) <> "0" Then Result = Result & GetTens(Mid(MyNumber, 2)) Else Result = Result & GetDigit(Mid(MyNumber, 3)) End If GetHundreds = Result End Function ' Converts a number from 10 to 99 into text. Function GetTens(TensText) Dim Result As String Result = "" ' Null out the temporary function value. If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19... Select Case Val(TensText) Case 10: Result = "Ten" Case 11: Result = "Eleven" Case 12: Result = "Twelve" Case 13: Result = "Thirteen" Case 14: Result = "Fourteen" Case 15: Result = "Fifteen" Case 16: Result = "Sixteen" Case 17: Result = "Seventeen" Case 18: Result = "Eighteen" Case 19: Result = "Nineteen" Case Else End Select Else ' If value between 20-99... Select Case Val(Left(TensText, 1)) Case 2: Result = "Twenty " Case 3: Result = "Thirty " Case 4: Result = "Forty " Case 5: Result = "Fifty " Case 6: Result = "Sixty " Case 7: Result = "Seventy " Case 8: Result = "Eighty " Case 9: Result = "Ninety " Case Else End Select Result = Result & GetDigit _ (Right(TensText, 1)) ' Retrieve ones place. End If GetTens = Result End Function ' Converts a number from 1 to 9 into text. Function GetDigit(Digit) Select Case Val(Digit) Case 1: GetDigit = "One" Case 2: GetDigit = "Two" Case 3: GetDigit = "Three" Case 4: GetDigit = "Four" Case 5: GetDigit = "Five" Case 6: GetDigit = "Six" Case 7: GetDigit = "Seven" Case 8: GetDigit = "Eight" Case 9: GetDigit = "Nine" Case Else: GetDigit = "" End Select End Function
uparrow.gifBack to the top How to use the SpellNumber sample function loadTOCNode(2, 'moreinformation'); To use the sample functions to change a number to written text, use one of the methods demonstrated in the following examples: uparrow.gifBack to the top Method 1: Direct Entry loadTOCNode(2, 'moreinformation'); You can change 32.50 into "Thirty Two Dollars and Fifty Cents" by entering the following formula into a cell: =SpellNumber(32.50) uparrow.gifBack to the top Method 2: Cell reference loadTOCNode(2, 'moreinformation'); You can refer to other cells in the workbook. For example, enter the number 32.50 into cell A1, and type the following formula into another cell: =SpellNumber(A1) uparrow.gifBack to the top Method 3: Paste Function or Insert Function loadTOCNode(2, 'moreinformation'); To enter a custom function into a worksheet, you can use Paste Function in Excel 2000, or you can use Insert Function in Excel 2002 and in Excel 2003. Excel 2000 loadTOCNode(3, 'moreinformation'); To use Paste Function, follow these steps:
  1. Select the cell that you want.
  2. Click Paste Function on the Standard toolbar.
  3. Under Function category, click User Defined.
  4. Under Function name, click SpellNumber, and then click OK.
  5. Enter the number or cell reference that you want, and then click OK.
Excel 2002 and Excel 2003 loadTOCNode(3, 'moreinformation'); To use Insert Function, follow these steps:
  1. Select the cell that you want.
  2. Click Insert Function on the Standard toolbar.
  3. Under Or select a category, click User Defined.
  4. In the Select a function list, click SpellNumber, and then click OK.
  5. Enter the number or cell reference that you want, and then click OK.

Apr 01, 2010 | Microsoft Windows XP Professional

1 Answer

I need to install or downloads Arabic language into my computer languages so I can type using Arabic keyboard thank you very much sam


Setting Up Arabic in Windows XP

Adding the Language to Windows

The following instructions will help you to set up your keyboard layout for Arabic that matches the DataCal Keyboard Labels.

Step 1. Install Supplemental Language Support
The Arabic language requires that you install Supplemental Language Support before you can set it up in Windows.
  1. Select the Start button in the lower left corner of the Desktop.
  2. Select the Control Panel (or, if you are using the Windows Classic Setting, select Settings > Control Panel).
  3. In the Control Panel, double-click the Regional and Language Options item.
  4. In the Regional and Languages dialog box, click on the Languages tab. In the Supplemental language support section, click on the Install files for complex script and right-to-left languages (including Thai) option (see Figure below).
  5. Click on the Apply button in the lower right corner of the dialog box and then click on the OK button. You may be prompted to insert your Windows install CD into the CD drive.

89ff32e.gif
Step 2. Add Language to Windows
  1. In the Control Panel, double-click the Regional and Language Options item.
  2. In the Regional and Languages dialog box, click on the Languages tab.
1. Click on the Details button in the Text services and input languages section of the Language tab to open the Text Services and Input Languages dialog box.

08db84d.gif
2. To add a language, click the Add button in the Installed services section to open the Add Input Language dialog box.

3. Click on the arrow to the right of the selector in the Input language selector and scroll to Arabic.


dd51530.gif
4. The Keyboard Layout/IME should default to the Arabic keyboard layout. If it does not, click on the arrow to the right of the selector in the Keyboard layout/IME selector and scroll to the Arabic keyboard layout. Note that there often are different keyboard layouts for a language. You should select the language and keyboard layout that matches the DataCal Keytop Label.

5. After you select the language and keyboard layout, click on the OK button to close the Add input language dialog box.

6. When you return to the Text services and input languages dialog box, you will see the new input language and keyboard layout included in the Installed Services box.

7. Click on the Apply button to apply the changes to the new layout. Note that each language features a small blue box in the Installed services section with 2 letters that indicates the language. English is designated as EN.


196bdcc.gif
  1. If you do not wish to add any additional languages or layouts, you can click on OK to close the Text services and input languages dialog box. When you return to the Windows Desktop, you can see the language bar in the lower right corner of the Desktop.
  2. To change the language and keyboard layout, click on the two-letter language selector box with the left mouse button to open the language selector menu.
  3. Click on the language that you wish to use in the language selector pop up menu.
The language you select will remain in effect in active Windows application until you select a different language. For example, if you select the Arabic language and keyboard layout in Microsoft Excel and English in Microsoft Word, each application will use that keyboard layout until you exit the application or you select a different language.

Default Keyboard Layout

If you wish to make a particular keyboard layout the default Windows layout (i.e., to be used in all Windows applications), open the Text services and input languages dialog box.
Select the desired keyboard layout to be the default in the Default input language section of the dialog box.

I hope it helps.
If you would like to vote for the answer, this will help the others to see the similar problems solved and also will be a satisfaction factor for me to continue helping you.
All the best.

Mar 27, 2010 | Microsoft Windows XP Professional for PC

1 Answer

Installing fonts as complex script in Microsoft word


you are correct in your assumptions on the fonts. I would suggest searching for "complex scripts" and choosing those you like preferrably in TrueType format for best performance try these and install by saving to your fonts folder.... http://www.fedu.uec.ac.jp/zzzthai/fonts.html

Mar 13, 2009 | Microsoft Windows Vista Business Edition...

1 Answer

How to change the language in ms office2003


Dear Akanksha,
You have to do it on two level
1. Using Control Panel
2. Using MS Office

Before doing that you have to do some preparation,
  • first keep windows installation CD Handy, whenever asked pl insert that.
  • Second, Download Indic IME, Windows XP LIP and Office 2003 LIP, Install them
  1. Now goto control panel --> Regional and language options --> Languages tab --> Check Install files for complex script, Install files for East Asian Languages (insert Win Installation CD when asked)

    In Advance tab select appropriate language for code conversion
  2. Download and Install fonts for your language
  3. in MS Word -->Tools Menu --> Language add your desired language
Having Problem please feel free to write or call

Zulfikar Ali
ali_zulfikar@yahoo.com
09899780221

Mar 06, 2009 | Microsoft Windows Server Standard 2003 for...

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

2 Answers

Conversion


click on the cell and press F2 and press 's near enter

Mar 04, 2008 | Microsoft Windows XP Professional for PC

Not finding what you are looking for?
Microsoft Windows XP Home Edition Logo

122 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Carlos L. Burgos
Carlos L. Burgos

Level 2 Expert

508 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...