autoformat to scientific numbers

[TomTom101]

Hi everybody,

how can I make Excel NOT touch values like '343e23' or large number
and turn them into scientific numbers.
Phonenumbers, passwords, timestamp are not save from being changed b
Excel - independent of the format settings of the cell.

One should think that choosing "text" as the cell format woul
re-convert the scientific number into a string again - which o.c. doe
not happen (I consider this as a bug, actually).

I have heard of that trick putting an ->'<- as the first character of
column so Excel sees it as a string - I find this solution not ver
elegant, though.

So thanks in advance for any tipps!

Thoma

 

[David Biddulph]

Hi everybody,

how can I make Excel NOT touch values like '343e23' or large numbers
and turn them into scientific numbers.
Phonenumbers, passwords, timestamp are not save from being changed by
Excel - independent of the format settings of the cell.

One should think that choosing "text" as the cell format would
re-convert the scientific number into a string again - which o.c. does
not happen (I consider this as a bug, actually).

I have heard of that trick putting an ->'<- as the first character of a
column so Excel sees it as a string - I find this solution not very
elegant, though.

So thanks in advance for any tipps!

If you format the cells as text before you enter the data you should be OK.