Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Christina
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Christina
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
convert scientific notation to a number Peter Excel Discussion (Misc queries) 1 January 4th 05 07:08 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Convert week number into calendar month? WickyWick Excel Worksheet Functions 2 November 9th 04 09:01 PM
How do I convert 300616a to show as a number 303616? SusanK Excel Worksheet Functions 3 November 9th 04 08:40 AM


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"