I suggest that you read the .Text value of the cell rather than the .Value of
the text and format it before writing out the text file. By doing this the
text file will contain the formatted text.

Alok Joshi

"LabElf" wrote:

> So far I've only tested this in Excel 2000, but a final solution would have
> to work in Excel 2003 as well.
>
> I'm reading data from cells in an Excel sheet and using the data to
> construct ascii text files. The particular problem I have is this:
> The cell I'm reading displays as "113:00:00" in Excel
> The format of the cell is Category - Time, Type - 37:30:55 (and the sample
> area shows "113:00:00" at this point.
> The formula bar shows "1/14/1900 5:00:00 PM"
> When reading the cell in my VB program, the raw value of the cell is
> "4.70833333333333"
> The NumberFormat property of the cell is "[h]:mm:ss"
> When I read the cell with this number format (using the Format function), I
> get the string ":01:00". The user would expect to see "113:00:00", which
> Excel shows him is there.
>
> How can I get the value that Excel is displaying, since using NumberFormat
> doesn't work? (I know I could just tell the users to use straight text or
> General format, but I would like to accommodate the users' desire to use
> Excel formats to make their work easier.)
> --
> In theory, there is no difference between theory and practice; in practice,
> there is.