Question about Microsoft Office Standard for PC

1 Answer

Numaric to TEXT

How can i comnvert the numerical degits in to text autometically in a specified text. for exeample: Cell A1 contains 100 value and Cell A2 contains 200 value. Now If Cell C1=A1+A2 then the C1 Will show the value 300. Now I want that in Cell D2 the value of C1 will be expressed in Text, i,e, "Rupees Three Hundred Only" --like this. Please help. Raju Saha You can also reply to

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 3 tips or uploaded 2 video tips.


    An expert whose answer got voted for 20 times.

  • Expert
  • 112 Answers

Raju, There's no easy way to do it as far as I know. What you can do is create a table where in column A you'll have the sum, in this case 300 and in column B you'll have the text i.e. Rupees Three Hundred Only Then you need to use the Vlookup function to retrieve the right text to the number you get.

Posted on Sep 18, 2007


1 Suggested Answer

  • 2 Answers

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

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

2 Answers

Need to have a certain cell say OFF when it is a certain day

Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 | Microsoft Excel for PC

1 Answer

My MS Excel vlookup function ASCII type table contains both upper case and lower case letters, characters like ( and % or *, and numbers. It seems to return the numerical equivalent of upper case letters...

Correct a #N/A error blueup_clv.gifShow All bluedrop_clv.gifHide All This error occurs when a value is not available to a function or formula.
  1. Optionally, click the cell that displays the error, click the button that appears ooui1_za06043871.gif, and then click Show Calculation Steps if it appears.
  2. Review the following possible causes and solutions. blueup_clv.gifMissing data, and #N/A or NA() has been entered in its place
    Replace #N/A with new data.
    Note You can enter #N/A in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.
    blueup_clv.gifGiving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function
    Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. blueup_clv.gifUsing the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table
    By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.
    blueup_clv.gifUsing an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula
    If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).
    blueup_clv.gifOmitting one or more required arguments from a built-in or custom worksheet function
    Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.
    blueup_clv.gifUsing a custom worksheet function that is not available
    Make sure that the workbook that contains the worksheet function is open and the function is working properly.
    blueup_clv.gifRunning a macro that enters a function that returns #N/A
    Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

1 Answer

When I create a formula in a cell, hit enter, I get #VALUE. How do I get the actual result to appear, instead of #VALUE?

#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

1 Answer

Text box restriction

I hope this helps and thanks for rating my effort...any other questions...shoot em to me....The Fang.

Restricting character input You can use the SetInputTextType command to restrict the characters that the user can enter in the text input dialog box. For example, suppose an application contains an input text field for users to provide a numeric value, such as their age, and that the input text field has the variable name ageVar. To ensure that the user enters only numeric values in the text input dialog box, you could add the following code to your application:
fscommand2("SetInputTextType", "ageVar", "Numeric");
When users open the input text dialog box, they can enter only numeric values in the text fields.
For more information, see SetInputTextType in the fscommand2 function entry in the Flash Lite 2.x ActionScript Language Reference.

May 28, 2009 | Adobe Flash® CS3 Professional Full Version...

1 Answer

Finding the right formula


  1. we work on sheet1, cell b1 as description of material and cell e1 as quantity figure.
  2. we will put the transfer the text in cell b1 to sheet2 cell a1 if you have entered some value in sheet1 cell e1. Otherwise sheet2 cell a1 will left empty or display some text as "NONE" or as you wish.
what you should do is make a formula in sheet2 cell a1 like this:


The formula will check sheet1 cell e1, if there is any number or text put in there, the value of Sheet1 cell b1 will be copied to sheet2 cell a1. If you don't supply any number or text in sheet1 cell e1, there's nothing will appeared in sheet2 cell a1.

If you want some text will display when there's no value in sheet1 cell e1 just change the formula like this:


You can modify it as your like. Just copy the formula to another row in sheet2 column a.

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC

2 Answers


To find the second character in a string in A1 use =mid(A2,2,1)
To check if it is a number use =isnumber(value(mid(A2,2,1)))

I hope this helps to get past the part you are stuck on - not being familiar with your problem it's difficult to give you any more advice.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Regarding Excel formulas

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

1 Answer

Excel help

Maybe this is what you need:
this is called "nested".
You can put nested if function maximum 7. (for more than 7, we should make another "trick")
if you put toilet in A1 then come the value B1*2
if you put bread in A1 then come the value B1*3
if you put star in A1 then come the value B1*4
Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

Apr 01, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Using if and then to add values to a cell

Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:

Here are SUMIF functions for multiple conditions.




Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

Dec 09, 2007 | Computers & Internet

2 Answers

When I enter a formula in a cell with the the insert functon device, it does not calculate itself, but shows as text

Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

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

Related Topics:

53 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18420 Answers

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

Answer questions

Manuals & User Guides