scientific notation in excel

[chals1]

Hi I'm trying to export data from matlab into excel but excel doesn't understand 8.000e+002 as 800
some help? thanks

 

[Gavona]

I copied the number from your post, pasted into excel, changed the format and it WAS recognised as 800.

I tried preceding the formula with an apostrophe. Then used Data, TextToColumns delimited but no delimiters and the column specified as general. This converted it to a number.

Again preceeding with an apostrophe giving a text value in A1. Refer to it from another cell to coe-erce excel into treating as a number:
=--A1

Gavin

 

[SkipVought]

or enter a 1 in an empty cell.

COPY that cell

Select the range containing the data with the sci notation.

Edit > Paste Special -- MULTIPLY

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[chals1]

Thanks. isaint a way to make excel automatically recognise this format after copypasting from matlab? I did this onto another computer and didn't have any problem.

 

[assets]

I may have misunderstood the question but by default the cel properties are general. You can change to special and set your own format. Also try paste special instead of paste It sometime get around problem I had with stats.


Never give up never give in.

There are no short cuts to anything worth doing

 

[chals1]

I have a dat file, created by a matlab script, which contains numbers separated by spaces; then I open it with excel but the scientific notation from matbab is not caught properly.

 

[SkipVought]

then I open it with excel but the scientific notation from matbab is not caught properly.

THERE is your problem!

Rather, in a new worksheet, IMPORT the file, and parse and explicitly define each column data type.

Once you have done this, you can REFRESH to get data, parsed ad defined identically, from a new file.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}