Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting text to numbers
Using your posted file, if you want to parse the text in Col_G across into
its numeric components Example: G2: 7 651 641 Becomes G2: 7 H2: 651 I2: 641 Then try this: Select Col_G From the Excel main menu: <data<text to columns Check: Delimited............click [next] in the Other box: (hold down the [alt] key...type 0160...release the [alt] key) Click [Finish] Does that help? *********** Regards, Ron XL2002, WinXP "Eirik Sævareid" wrote: When issuing a report, I have a need for extracting data from a production control system. The data are being saved in HTML-format, and then saved into Microsoft Excel. The numbers then occur stored as text-format in Excel. I have not succeded when trying to convert them into number-format (the numbers are going to be used in further calculations). Please see the attached Microsoft Excel-file. Have anybody the solution for my problem ? The report is bigger than the sample in the attached spreadsheet. All help will be greatly appreciated. Best regards, Eirik Sævareid |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting text to numbers
I forgot to mention....
if you want to fraction to remain a numeric fraction... Either set the numeric format of the cell to "fraction" OR when entering the fraction, precede it with a zero and a space: e.g. 0 1/4 would have a value of 0.25, but display as 1/4 Does that help? *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Using your posted file, if you want to parse the text in Col_G across into its numeric components Example: G2: 7 651 641 Becomes G2: 7 H2: 651 I2: 641 Then try this: Select Col_G From the Excel main menu: <data<text to columns Check: Delimited............click [next] in the Other box: (hold down the [alt] key...type 0160...release the [alt] key) Click [Finish] Does that help? *********** Regards, Ron XL2002, WinXP "Eirik Sævareid" wrote: When issuing a report, I have a need for extracting data from a production control system. The data are being saved in HTML-format, and then saved into Microsoft Excel. The numbers then occur stored as text-format in Excel. I have not succeded when trying to convert them into number-format (the numbers are going to be used in further calculations). Please see the attached Microsoft Excel-file. Have anybody the solution for my problem ? The report is bigger than the sample in the attached spreadsheet. All help will be greatly appreciated. Best regards, Eirik Sævareid |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting text to numbers
Please excuse my second post....NOT related in any way to your issue and
should have been posted to another thread. *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: I forgot to mention.... if you want to fraction to remain a numeric fraction... Either set the numeric format of the cell to "fraction" OR when entering the fraction, precede it with a zero and a space: e.g. 0 1/4 would have a value of 0.25, but display as 1/4 Does that help? *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Using your posted file, if you want to parse the text in Col_G across into its numeric components Example: G2: 7 651 641 Becomes G2: 7 H2: 651 I2: 641 Then try this: Select Col_G From the Excel main menu: <data<text to columns Check: Delimited............click [next] in the Other box: (hold down the [alt] key...type 0160...release the [alt] key) Click [Finish] Does that help? *********** Regards, Ron XL2002, WinXP "Eirik Sævareid" wrote: When issuing a report, I have a need for extracting data from a production control system. The data are being saved in HTML-format, and then saved into Microsoft Excel. The numbers then occur stored as text-format in Excel. I have not succeded when trying to convert them into number-format (the numbers are going to be used in further calculations). Please see the attached Microsoft Excel-file. Have anybody the solution for my problem ? The report is bigger than the sample in the attached spreadsheet. All help will be greatly appreciated. Best regards, Eirik Sævareid |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text to numbers | Excel Discussion (Misc queries) | |||
Converting numbers to text | Excel Discussion (Misc queries) | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
Converting text to numbers | Excel Worksheet Functions | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) |