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/