convert string to number

C

Christina

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
 
F

Frank Kabel

Hi
you may provide some more detail. But you may have alook at the vALUE function
 
C

Christina

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
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To make pdf to work as word 1
Word- Find and Replace 1
Having a 'not applicable' with a 0 ranking on a rating question 0
How can the font and size of (all) citation numbers be altered? 1
Excel does not accept text format! 0
Convert library to list 0
Julian Date Conversion 1
WORD VBA Search and switch to advanced ... 1

Top