Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formular or format to change 1 to one
Is there a formular or format to change a number "1" into the word "one".
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formular or format to change 1 to one
Hi Kevin,
See: http://www.xldynamic.com/source/xld.xlFAQ0004.html --- Regards, Norman "Kevin" wrote in message ... Is there a formular or format to change a number "1" into the word "one". |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formular or format to change 1 to one
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH RP (remove nothere from the email address if mailing direct) "Kevin" wrote in message ... Is there a formular or format to change a number "1" into the word "one". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formular or format to change 1 to one
First select the cells that you want to change. Then pull-down:
Edit Find and enter 1 in the what field and one in the replace field and then click replace all -- Gary's Student "Kevin" wrote: Is there a formular or format to change a number "1" into the word "one". |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formular or format to change 1 to one
Thanks
"Norman Jones" wrote: Hi Kevin, See: http://www.xldynamic.com/source/xld.xlFAQ0004.html --- Regards, Norman "Kevin" wrote in message ... Is there a formular or format to change a number "1" into the word "one". |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formular or format to change 1 to one
Thanks for the tip. Is there one that does the numbers without the dollars
and cents. Kevin "Norman Jones" wrote: Hi Kevin, See: http://www.xldynamic.com/source/xld.xlFAQ0004.html --- Regards, Norman "Kevin" wrote in message ... Is there a formular or format to change a number "1" into the word "one". |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formular or format to change 1 to one
Hi Kevin
To convert whole numbers, or integer values, try this minor adaptation of the main SpellNumber function: '============ Function SpellNumber(ByVal MyNumber) Dim sStr As String Dim Temp As Variant 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, ".") ' Remove decimals If DecimalPlace 0 Then MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber < "" Temp = GetHundreds(Right(MyNumber, 3)) If Temp < "" Then sStr = Temp & Place(Count) & sStr If Len(MyNumber) 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop SpellNumber = sStr End Function '<<============ --- Regards, Norman "Kevin" wrote in message ... Thanks for the tip. Is there one that does the numbers without the dollars and cents. Kevin "Norman Jones" wrote: Hi Kevin, See: http://www.xldynamic.com/source/xld.xlFAQ0004.html --- Regards, Norman "Kevin" wrote in message ... Is there a formular or format to change a number "1" into the word "one". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to change the default number format in Excel? | Excel Discussion (Misc queries) | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |