G
Gmooron
Hi !
I have to convert text files so as they can be read properly by excel.
If there was no problem to indicate correctly cells (with tabulation)
and to represent numbers properly, it still remains one :
There are some numbers I would like to be treated as text, but excel
treats them as numbers (strange isn't it ?? ;D). I thought I had found
a solution by inserting a " before these numbers (like "1543074 for
example), but unhappily, Excel doesn't treat the tabs properly after
that and the solution is worse than the illness.
You will tell me that I just have to select the column and tells it
that it is text, but my boss doesn't want this solution ... :/
So, I don't know what to do, the only solution I found for the moment
is to add an inelegant ' which remains when opening the file.... (ex :
'1541204)
Has everyone any idea ??
PS : Excuse my English
I have to convert text files so as they can be read properly by excel.
If there was no problem to indicate correctly cells (with tabulation)
and to represent numbers properly, it still remains one :
There are some numbers I would like to be treated as text, but excel
treats them as numbers (strange isn't it ?? ;D). I thought I had found
a solution by inserting a " before these numbers (like "1543074 for
example), but unhappily, Excel doesn't treat the tabs properly after
that and the solution is worse than the illness.
You will tell me that I just have to select the column and tells it
that it is text, but my boss doesn't want this solution ... :/
So, I don't know what to do, the only solution I found for the moment
is to add an inelegant ' which remains when opening the file.... (ex :
'1541204)
Has everyone any idea ??
PS : Excuse my English