Hi everyone, I'm using W'98 with Office'97. One of the clients I work for sends me files in Excel format. In some of the data there are % values. Ultimately I want to import these data into Access and do calculations on them. On importing these values to Access a text fied results, and I'm offered no way to change the field type. Further, if I attempt to change the field type in Access these values become 1's (I knew this would happen). Consider these data A B 1 34.32% 2 87.29% I can enter the statement "=A1*100" in the B1 cell and derive the numeric value 34.32. Extending the formula down the B column converts these data to numeric, I can do a variety of calculations, and the world is a wonderful place. However, I need to import these data into Access. Access doesn't import calculated fields. So, the question is, how can I convert from a % to a number field type that would allow me to import into Access? All help is appreciated and welcome. Regards, Paul Roeth PCSOFT maintains many useful files for download visit our download web page at: http://freepctech.com/downloads.shtml