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
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