Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert string to number
Hi there,
I need your help, please. How can I convert a stingfield to a integerfield in excel 97? It´s very important. Thanks in advance! Christina |
#2
|
|||
|
|||
Hi
you may provide some more detail. But you may have alook at the vALUE function "Christina" wrote: Hi there, I need your help, please. How can I convert a stingfield to a integerfield in excel 97? It´s very important. Thanks in advance! Christina |
#3
|
|||
|
|||
Allright. I have an application which exports a file as a xls file. The cells
in this file are strings but I need numbers. So how can I convert these strings to numbers? Thanks in advance! Christina "Frank Kabel" schrieb: Hi you may provide some more detail. But you may have alook at the vALUE function "Christina" wrote: Hi there, I need your help, please. How can I convert a stingfield to a integerfield in excel 97? It´s very important. Thanks in advance! Christina |
#4
|
|||
|
|||
Hi Christina
try this, select a blank cell on another worksheet that you've not played with and copy it now select all of your cells and choose edit / paste special - ADD this should put them all back to numbers Cheers julieD "Christina" wrote in message ... Allright. I have an application which exports a file as a xls file. The cells in this file are strings but I need numbers. So how can I convert these strings to numbers? Thanks in advance! Christina "Frank Kabel" schrieb: Hi you may provide some more detail. But you may have alook at the vALUE function "Christina" wrote: Hi there, I need your help, please. How can I convert a stingfield to a integerfield in excel 97? It´s very important. Thanks in advance! Christina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
convert scientific notation to a number | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Convert week number into calendar month? | Excel Worksheet Functions | |||
How do I convert 300616a to show as a number 303616? | Excel Worksheet Functions |