autoformat to scientific numbers

  • Thread starter Thread starter TomTom101
  • Start date Start date
T

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
 
TomTom101 > said:
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.
 
Back
Top