Value change when outputting to Excel (Access 2003)

[John Bartley K7AAY]

When I output a table's values to XLS, one value in a very small
table, and only one value, is changed.

Here are the values in the table, tblLevel.

LEVEL
H-14
0
1
1.1
1.2
1.3
1b
2
2.1
2.2
3
3.1
3.2
3b
4
4.1
4.2
4a
5
5.1
High
Low
Main
Medium

Yet, when output to Excel as an XLS, here's what Access created:
LEVEL
H-14
0
1
1.1
1.2
1.3
1b
2
2.1
2.2
3
3.1
3.2
3b
4
4.1
4.2
0.166666667
5
5.1
High
Low
Main
Medium


If I change the value from 4a to 4b, 4b is output to Excel, but when I
change the value back to 4a, once again Excel gets the value
0.166666667.


Field Properties are as follows:
LEVEL is a text field.
Field size is 10
Data entry required is Yes
Allow Zero Length is No
Indexed is Yes (No Duplicates)
Unicode Compression is No
IME Mode is No Control
IME Sentence Mode is None
The Display Control is a Text Box.

I do this export with many other tables, and don't get this error.

Your on-topic suggestions will be graciously appreciated.

 

[J_Goddard via AccessMonster.com]

What happens if you change 1b to 1a and 3b to 3a and do the export?

John