How to disable auto-convert ?

R

RagDyer

Format as text *before* you enter the data,
Or
Prefix the data with an apostrophe (') - '8/5.

If importing data, pre-format appropriate cells as text, then "PasteSpecial"
as "Values".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,

I'm opening a text file using Excel 2000 and the text file
contains values with slash, e.g. 8/5. By default, Excel
converts it to date and dispaly as "5th of Aug". When I
change the cell format to TEXT, its value is 38204.

Can anyone tell me how to disable this auto-convert so I
can get 8 & 5 respectively.

Thanks!
 
B

Bernie Deitrick

Frankie,

In the third step of the file open wizard, specify that the column should be
formatted as text. When you convert to text after the fact, you're too
late, just changing the date formatted value to its underlying value.

HTH,
Bernie
MS Excel MVP
 
F

frankie

Hi,

I'm opening a text file using Excel 2000 and the text file
contains values with slash, e.g. 8/5. By default, Excel
converts it to date and dispaly as "5th of Aug". When I
change the cell format to TEXT, its value is 38204.

Can anyone tell me how to disable this auto-convert so I
can get 8 & 5 respectively.

Thanks!
 
C

CLR

Format the cell for TEXT "before" you put the 8/5 in it or enter the value
in with a leading apostrophe, as '8/5 (the apostrophe won't show)

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Sorry...........after seeing Bernie's response, I realized I had mis-read
the original post.........just ignore my offering........

Vaya con Dios,
Chuck, CABGx3
 
Top