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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How can i convert documents in wordpad 2003 frm 2007 in windows 2


Open the file in word 2007 and from the office menu take the option CONVERT!

Then the things you want to convert are done..

May 30, 2010 | Microsoft Office Professional 2007 Full...

2 Answers

Convert function


BAHTTEXT(number)

The above function will convert a number to text. If you are referring to "figure" as a number than this should work for you.

You may want to try the TEXT(value,format_text) fucntion too but you'll need to supply a number format.

Apr 22, 2009 | Microsoft Office Excel 2003 for PC

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

1 Answer

Conversion of nemeric value


If you just want to change the format to text in a query, you can use the Str function in your query. In MS Access, in the Field area of your query in Design View, you can type the following:
YourDesiredCharFieldName: Str([YourNumericFieldName]).

On the other hand, if you prefer to convert the data once and for all in your table, you can go to the Table Design View for that Table, change the Data Type of your numeric field to "Text", and close that window to save the changes. This will convert all of your data in that field from numeric to text permanently.

Jul 01, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Excel


First a question - is this school homework?

I ask because I have just spent about 2 hours on creating the answer - there is no function to do this except to convert to text as currency in Thai.

May 12, 2008 | Computers & Internet

1 Answer

How to convert a pdf file in excel


Dear Gatta,
for this conversion you have to install Adobe Professional 7 Version in your computer . by this software you can convert any Word and Excel file in to PDF and vice versa.

Takecare

Mar 25, 2008 | Computers & Internet

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

124 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18355 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...