the number 0.857638888888889 is the serial number for 20:35:00, Excel
convert the time to a number.

I think you need a helper column, you may place this column out of the way
from your dataset and you can hide this, assume that this will be at col Z1,
place this formula
=TEXT(B1,"h:mm:ss"), this will change the time into a text
and link your text box to Z1, you shpuld now see 20:35:00

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis





"Parvaiz" wrote:

Hi Francis,
Yes - I already did that to the cells within the spreadsheet itself. So in
the spreadsheet, theye are picking up the correct format. Its just when I
refer to a cell via the form text box control's 'Control Source', i put in
for example B1 to refer to cell B1 but the form text box displays a long
decimal value which meens nothing.

All I want is say the cell B! value of 20:35:00 to be displayed as 20:35:00
on the forms text box. I need the text box so that a user can change the time
if they need to.

"francis" wrote:

are you able to apply Custom format [hh:mm:ss] to it via
Format Cells Custom Type?

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis




"Parvaiz" wrote:

Hi I have an Excel spreadsheet that contains times in the format of hh:mm:ss
I have created a simple form and I would like it to display the value of eg:
cell B1 = 20:35:00 (8 35 pm)
I put B1 in the Forms Text Box Control Source, but instead of displaying
20:30:00
I get 0.857638888888889

How do I get the text control box on the form to display in the same way as
the cell in the spreadsheet?

I have a column containing several rows of times in the spreadsheet. I guess
that if I can get one to show correctly, I should hopefully then be able to
apply the same logic to the rest of the times.

Any help would be very much appreciated as I only have a day left to hand
his in!