convert number into text

I am using the attached code for converting numbers (currency) into text. The code was working fine but now gives a "Compile error : Cant find project or library" please help to find what has gone wrong now. the code stops at "ReDim Place(9) As String" line. Function SpellIndian(ByVal...

Hello, I have a huge list, I want to change my reference columns data from number to text. I don't want to add any new column and for instance, use text() function. I am just wondering if it is possible to do that in place with a VBA code or not. I tried selection=selection.text and...

Hi There - I am trying to take convert my variable LC1 into a letter. Please see code below. I need to replace the hardcoded "C" with the equilvalent letter of LC1. Thanks! Dim LR1 As Long Dim LC1 As Long LR1 = Range("A:AO").Find("*", SearchOrder:=xlByRows...

I would like to take all numbers in column C of my spreadsheet and turn them into text based on the text value I gave each number. Ex: I would type the number "1" into cell C1 and excel would automatically convert it into the word "New York". If I typed "2" into a cell it would convert in into...