Incorrect time displayed in cell

[Phone_Guy]

I'm trying to create a invoice number cell that incorporates the account number from cell C3 and the date and time the invoice was created. I entered this in the cell:

=C3&" "&TEXT(A12,"MM-DD-YY-HH-MM ")

It does bring in the account number and the correct date, but the time displays as 0-00. Is what I'm trying to do possible? If I remove the TEXT command and just enter:

=C3&" "&NOW() it does post the account number and excels integer version of the time. Any ideas how to make this work?Thanks

 

[Jonmo1]

Works for me.

Best guess is that A12 DOES NOT contain the time, only the Date..

To see, format A12 as a NUMBER with about 5 or 6 decimals.
If you only see a whole # and no decimal, then that cell holds ONLY the date.

 

[Phone_Guy]

thanks for your quick reply. Your correct. I should have pick that up.However is there another way I can enter the account number as well as the date and time into the invoice number field without changing the date format to display the time in cell A12? It just doesn't look very good there. I really need the time stamp in the invoice number field in case we (rarely will happen) bill a customer twice in one day so that we can distinguish the two invoices.

 

[Phone_Guy]

Thanks for pointing me in the right direction. I changed the command in the reference cell from =TODAY() to the =NOW() and it now works perfect.