date and time formatting

[Lane]

I have a formula in which the date and time are present in cells, bu
when the destination cell returns them, they are in their numerica
value. I need them to appear in the destination cell the same way the
do in their home cells.

here is the formula:

="p-v-w-"&B154&" ph "&E154&" fax "&H154&" ** "&X154&" * "&Y154&"
"&AA154&" * "&" * "&AB154&" "&(Y4)&" - "&(Y5)

y4 and y5 are the date and time cell refs

Thanks and Happy Holidays to all!

 

[Guest]

You need to put the cell references inside TEXT functions

Good Luck
Mark Graesse
(e-mail address removed)

----- Lane wrote: ----


I have a formula in which the date and time are present in cells, bu
when the destination cell returns them, they are in their numerica
value. I need them to appear in the destination cell the same way the
do in their home cells

here is the formula

="p-v-w-"&B154&" ph "&E154&" fax "&H154&" ** "&X154&" * "&Y154&"
"&AA154&" * "&" * "&AB154&" "&(Y4)&" - "&(Y5

y4 and y5 are the date and time cell ref

Thanks and Happy Holidays to all!

 

[Dave Peterson]

so you could use this instead of just B154:

.....&text(b154,"mm/dd/yyyy hh:mm:ss")&" ph "&....