Hello,

I have the following table:

A B

20 KG

10 G

30 G

15 KG

I would like to select only cells written in G (10 and 30) and multiply them by 1000 to get KG.

How would you do that please? In a general way, how do you multiply/divide ony cells that you have selected at the same time?

Many thanks,

Antonin.

I have the following table:

A B

20 KG

10 G

30 G

15 KG

I would like to select only cells written in G (10 and 30) and multiply them by 1000 to get KG.

How would you do that please? In a general way, how do you multiply/divide ony cells that you have selected at the same time?

Many thanks,

Antonin.

- Excel should have a formula to convert number into words
- Convert number into words
- Convert digit into text (alphabet)
- How to convert Numbers into text
- Excel should have a formula to convert number into words
- Converting seconds into minutes
- Convert number into Date Format
- Any one tried converting VBA into VS to take advantage of multicore CPUs?
- Formula To Convert Months Into Weeks
- Convert Minutes Into Decimal Hours
- Convert grams into pounds and ounces
- Converting days into weeks
- Excel converts fractions into dates. Make it stop.
- Extracting a number from a string and converting it into an Intege
- How do I convert numbers into words in excell worksheet?
- Convert Numeric into Text
- Convert HTML into an Excel
- How to convert nos into word format say 500 to Five Hundred
- How to convert text into range reference?
- Converting dates into their respective fiscal quarters
- How to convert number into word in excel i.e. 100 to one hundred
- Can any one tell me how to convert figures into words automatical.
- Any one tried converting VBA into VS to take advantage of multicore CPUs?
- Do u know about Excel tool that would convert figures into words

convert it into words. e.g. 3,451 ... Three thousand four hundred and

fifty-one

----------------

This post is a suggestion for Microsoft, and Microsoft responds to the

suggestions with the most votes. To vote for this suggestion, click the "I

Agree" button in the message pane. If you do not see the button, follow this

link to open the suggestion in the Microsoft Web-based Newsreader and then

click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Can any one help me to convert numeric into words (without Currency USD,

EURO, just words), e. g.,

15,015.27

Fifteen thousand fifteen and twenty seven only

Rgds

Blackwar

If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat

will be the formula for it?

convert it into words. e.g. 3,451 ... Three thousand four hundred and

fifty-one

----------------

This post is a suggestion for Microsoft, and Microsoft responds to the

suggestions with the most votes. To vote for this suggestion, click the "I

Agree" button in the message pane. If you do not see the button, follow this

link to open the suggestion in the Microsoft Web-based Newsreader and then

click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

Now I hv another problem. I need those seconds to be converted into Minutes.

Here is the example of converting secs. to hrs:

VB:test() Dim myanswer As Variant myanswer = Str((Range("H11").Value)) MsgBox (Int(myanswer) * 24) + Round(((myanswer - Int(myanswer)) * 24), 2) End SubIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Can any Guru out there help me to convert number into date. For example in column A I have many numbers like 200006, 200410, 200208, 200001, and so on. How can I make Excel reads the number 200006 as the date 2000/06 or 200410 as the date 2004/10 without using VBA?

I read something about converting VBA into Visual Studio to do multi-threading

http://betterandfasterdecisions.com/...rmance-review/

Any one has tried it to take advantage of multicore CPUs?

Is it hard? Can we still call excel functions like application.vlookup in the program?

I'm having an issue converting months into weeks. My example is I have people who must provide leaving notice (could be months or weeks). For instance column B details months, and column C details weeks. I'd like to convert months (column B) into weeks in column D, but am not sure of the components of such a formula so I won't list or guess as I'm just not sure.

Your help is greatly appreciated.

Crusader

780 grams

=

1lb 10oz

only 5 days showing, but this shows up as 0.7. The formula I am using is

D3/7 and i have also tried (D3-1)/7 and this shows 0.6.

--

Message posted via http://www.officekb.com

into a date. This is a pain when I am trying to paste a table with fractions,

because I have to go back and manually enter them all.

----------------

This post is a suggestion for Microsoft, and Microsoft responds to the

suggestions with the most votes. To vote for this suggestion, click the "I

Agree" button in the message pane. If you do not see the button, follow this

link to open the suggestion in the Microsoft Web-based Newsreader and then

click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I have a text string from which I would like to extract a particular value,

that is the number at the end, and then convert it into an integer value. The

String is;

Total item(s) found: 1

From which I want to be able to take the number at the end and convert it

into an integer.

Can anyone please assist in formulating a solution for doing that.

Thanks

Sumeet

excess worksheet. This would help me for preparing invoices.

Enter the following macro:-

Option Explicit

'****************' Main Function *'****************

Function SpellNumber(ByVal MyNumber, Optional IncludePence As Boolean = True)

Dim Pounds, Pence, 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 Pence and set MyNumber to Pound amount

If DecimalPlace > 0 Then

Pence = 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 Pounds = Temp & Place(Count) & Pounds

If Len(MyNumber) > 3 Then

MyNumber = Left(MyNumber, Len(MyNumber) - 3)

Else

MyNumber = ""

End If

Count = Count + 1

Loop

Select Case Pounds

Case ""

Pounds = "No Pounds"

Case "One"

Pounds = "One Pounds"

Case Else

Pounds = Pounds & " Pounds"

End Select

If IncludePence = False Then

Pence = ""

Else

Select Case Pence

Case ""

Pence = " and No Pence"

Case "One"

Pence = " and One Pence"

Case Else

Pence = " and " & Pence & " Pence"

End Select

End If

SpellNumber = Pounds & Pence

End Function

Monty wrote:

>

> I have input the following formula in order to convert numbers into words.

> the problem is i am working form three work sheets and the formula works

> fine for the first two however in the last worksheet i do not want to

> transfer pence over, how can i get round this if a need pence in the first

> and second sheet but not on the third. see below for macro.

>

> Sub bb()

>

> End Sub

> Option Explicit

>

> '****************' Main Function *'****************

> Function SpellNumber(ByVal MyNumber)

> Dim Pounds, Pence, 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 Pence and set MyNumber to Pound amount

> If DecimalPlace > 0 Then

> Pence = 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 Pounds = Temp & Place(Count) & Pounds

> If Len(MyNumber) > 3 Then

> MyNumber = Left(MyNumber, Len(MyNumber) - 3)

> Else

> MyNumber = ""

> End If

> Count = Count + 1

> Loop

> Select Case Pounds

> Case ""

> Pounds = "No Pounds"

> Case "One"

> Pounds = "One Pounds"

> Case Else

> Pounds = Pounds & " Pounds"

> End Select

> Select Case Pence

> Case ""

> Pence = " and No Pence"

> Case "One"

> Pence = " and One Pence"

> Case Else

> Pence = " and " & Pence & " Pence"

> End Select

> SpellNumber = Pounds & Pence

> 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

hope this helps you

"Shahid" wrote:

> In MS Excel I need to convert a numeric value into tex, i.e. 1250="one

> thousand two hundred fifty"

Excel so I could modify and delete unnecessary data. I tried to open the

HTML file in Excel, but it was too big so only part of it was imported into

Excel.

Does anyone know how to either: a) import the entire HTML file; or b)

selectively import the HTML into Excel since the file is too big?

Thank you very much.

We have huge data containing no's, would like convert the same into word

format

Example to convert

1 One

2 two

3 three

4 four

of date-named files, and I am trying to assemble them back into the same

table using VLOOKUP function, where I have to change the workbook source

names - and I am getting an error, indicating that my reference is a text

string (which it is), not the proper reference.

Example:

What it should be:

A1= '11-20 (date)

B1= 'C:Folder11-20 sales.xls'!data$A$1:$D$35 (reference text as a result

of a formula)

C1=vlookup(A1,indirect(B1),false,2) - ref error

When I tried to concantinate the reference in the vlookup formula itself I

got value error from inability to convert text into reference link, like this:

vlookup(A1,"'C:Folder11-20 sales.xls'!data$A$1:$D$35",false,2)

Appreciate your help,

PS I am not good with VB.

I have gotten this formula thru the help of someone. It converts dates into

their respective fiscal quarters. The formula is:

="Q"&INDEX({4;1;2;3},INT((MONTH(A2)+2)/3))

However, this formula uses a fiscal year which starts on April 1st. I need

the formula to start on 1st Nov as its start of a fiscal year. Can anyone

advice on this, thanks.

wrote 100 in a cell it should show me "one hunderd" in a corresponding cell.

I tried and find out a function "bahttex" which convert number into words;

but this function shows the answer in the THAI language, again need is there

to convert the THAI language to english langauge.

Can anybody help me out in this regard?

Thanks

Shiv Trehan

excel

like

660 is converted six hundred sixty

I read something about converting VBA into Visual Studio to do multi-threading

http://betterandfasterdecisions.com/...rmance-review/

Any one has tried it to take advantage of multicore CPUs?

Is it hard? Can we still call excel functions like application.vlookup in the program?