help on excel....

[spp]

i have a bunch of data in the form like

1.531u
1.633u
....... and so on..... where u is micron (e-6).... the excel graph doesn't recognize it, so my graph is all messed up.

Is there anyway to tell excel to convert the u, n, m, and such into e-6, e-9, and such?

 

[nateholtrop]

format the cell for text instead of number

nate

 

[spp]

for text?? but i want it to be number though (e-6..... .10^6....... scientific notation??)

 

[notfred]

$number = "1.531u";
$number =~ s/[^\d.]//g;
$number /= 1000000;

 

[spp]

$number = "1.531u";
$number =~ s/[^\d.]//g;
$number /= 1000000;


sorry i'm dumb..... do you mind explaining that??