Urgent Help

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Dec 13, 2003

• #2

I can't be certain that this is the most clever approach:

Book1
	A	B	C	D	E
1	2	2	2	2	8
Sheet1

Edit: I like this better:

Book1
	A	B	C	D	E
1	2	2	2	2	8
Sheet1

 

Upvote 0

S

saurabh726

Well-known Member

Joined

Dec 13, 2003

Messages

891

• Dec 13, 2003

• #3

well see i got some values and they are been saved from html to excel

for ex
el ftr rptd
New Activation 2 3 4
Confirmation 3 2 2


Now all these numbers are in text format like i cant apply anything on them i want to convert them into number format and that formula is not working same its giveing me the result in !value

Thanx
Saurabh

Edited by NPO: Deleted bb tag.

 

Upvote 0

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Dec 13, 2003

• #4

Hello again,

Did you try the 2nd function? It'll coerce numeric data presented as a string to a numeric data type. The html maker is showing my cells as numbers (it's coercing too! ), but my sheet really has this array of cells set up as strings.

The first one (not preferred!) needs to be entered without the braces, then array entered by hitting ctrl-shift-enter in the formula bar.

 

Upvote 0

S

saurabh726

Well-known Member

Joined

Dec 13, 2003

Messages

891

• Dec 13, 2003

• #5

No i havent tried that what im basically looking for is to convert these numbers which are not adding up into number format or i want to add them not to multiply however ur result is same coz u have all the same values but if the values are not same then the result will be different give me a formula through which i can sum all these numbers coz they are not getting add.

Thanx
Saurabh

 

Upvote 0

N

Nimrod

MrExcel MVP

Joined

Apr 29, 2002

Messages

6,259

• Dec 13, 2003

• #6

Just thought I'd mention a "Built In" solution for change text to number format:

For example lets say you text 23 in cells A1:B5...
Step 1: Type the number "1" in an empty cell
Step 2: Select the "1" then right click and choose "copy"
Step 3: Select range A1:B5 and right click and choose "Special Paste"
Step 4: In Special Paste Window Select "Multiply"... Done !

Please note that this will work on Txt "23" but not on text "2 3". For the later you'd first need to do a replace to get rid of the space !

 

Upvote 0

S

saurabh726

Well-known Member

Joined

Dec 13, 2003

Messages

891

• Dec 13, 2003

• #7

did that but still the result is not able to add that on doing that it shows me !value. it does not get add up.

Thanx
Saurabh

 

Upvote 0

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Dec 13, 2003

• #8

saurabh726 said:

No i havent tried that what im basically looking for is to convert these numbers which are not adding up into number format or i want to add them not to multiply however ur result is same coz u have all the same values but if the values are not same then the result will be different give me a formula through which i can sum all these numbers coz they are not getting add.

Thanx
Saurabh

Click to expand...

Yes, I followed you. Perhaps you should try it, before commenting on the nature of the functionality.

Book1
	A	B	C	D	E
1	2	2	2	6	12
Sheet1

Your call... You did want a solution, right? Copying and implementing the proposed solution shouldn't prove to be too big a burden in my estimation.

Incidentally Nimrod, this is native functionality.

 

Upvote 0

S

saurabh726

Well-known Member

Joined

Dec 13, 2003

Messages

891

• Dec 13, 2003

• #9

 New activation pending related  0  1  0
Pending conversions 0 0 0
Not Created   1  0  1
 Conversion 1 17  0
Conversion from  0  7  0
 Magic To   5  22  3
 Conversion  0  14  0


here are some exact number that im talking about because these numbers are not getting added up and hey nato i tried that also but its giving me value only

Thanx
Saurabh

 

Upvote 0

S

saurabh726

Well-known Member

Joined

Dec 13, 2003

Messages

891

• Dec 13, 2003

• #10

[C:\Documents and Settings\sgrover01\Desktop\mis for 12th dec.htm]

IF IT GETS ATTACHED SOME OF USE[/url]

 

Upvote 0