HI,

I am trying to stop large numbers such as
0.0977376573888888 being read into vb as

9.77376573888888E-02 when I import using the following

strRate=xlApp.Worksheets(intSheetNo).Range(strRate Col & intI).Value

I wish to read that number and format it to 4 decimal places
as follows

..0977.
However, it is already read in in scientific notation so I cannot
format it then. Does anyone know how to solve this?

Thanks

Molly


---
Message posted from http://www.ExcelForum.com/