Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i make numbers have text format without insering ' at each
I have a file with 10000 numbers and I want them to be in "text" format. I do
the basics (format-cell-text) but only when I insert ' or edit the cell (F2+ENTER)I have the right results. is there an easier way which is less time consuming? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i make numbers have text format without insering ' at each
"Numbers into text format in excel" wrote...
I have a file with 10000 numbers and I want them to be in "text" format. I do the basics (format-cell-text) but only when I insert ' or edit the cell (F2+ENTER)I have the right results. is there an easier way which is less time consuming? You'd have to do the following for each column of values. Select a column of values you want to convert to text. Run the menu command Data Text to Columns. Select Fixed Width in the first screen of the wizard and click the NExt button. Immediately click the Next button in the second screen of the wizard. Select Text in the Column data format section of the third screen of the wizard and click the Finish button. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i make numbers have text format without insering ' at
thanks a lot!!!
"Harlan Grove" wrote: "Numbers into text format in excel" wrote... I have a file with 10000 numbers and I want them to be in "text" format. I do the basics (format-cell-text) but only when I insert ' or edit the cell (F2+ENTER)I have the right results. is there an easier way which is less time consuming? You'd have to do the following for each column of values. Select a column of values you want to convert to text. Run the menu command Data Text to Columns. Select Fixed Width in the first screen of the wizard and click the NExt button. Immediately click the Next button in the second screen of the wizard. Select Text in the Column data format section of the third screen of the wizard and click the Finish button. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i make numbers have text format without insering ' at each
Sub Add_Text_Left()
Dim cell As Range Dim moretext As String Dim thisrng As Range On Error GoTo endit Set thisrng = Range(ActiveCell.Address & "," & Selection.Address) _ .SpecialCells(xlCellTypeConstants) moretext = InputBox("Enter your Text") For Each cell In thisrng cell.Value = moretext & cell.Value Next Exit Sub endit: MsgBox "only formulas in range" End Sub Select the column of numbers then run the macro. Enter an apostrophe into the inputbox. Gord Dibben MS Excel MVP On Wed, 18 Jul 2007 01:38:01 -0700, Numbers into text format in excel <Numbers into text format in wrote: I have a file with 10000 numbers and I want them to be in "text" format. I do the basics (format-cell-text) but only when I insert ' or edit the cell (F2+ENTER)I have the right results. is there an easier way which is less time consuming? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
numbers in text format | Excel Worksheet Functions | |||
Format text to numbers | Excel Discussion (Misc queries) | |||
Parse text & numbers & format | Excel Worksheet Functions | |||
How do i change numbers in text format to number format? | New Users to Excel |