Locking a Date/Time Format

Basicly I have a lot of cells that have the following Date/Time format:

11/8/06 14:17

Or Short Date + Military Time. I want to combine this in a Macro produced report with information in the next column over which specifies the Time Zone to proceed the following:

11/8/06 14:17 PST

Unfortunately what I get is:

11/8/06 2:17:00 PM PST

Which is not at all what I want

Can anyone help with this? Basically what I want is a way to freeze the forming that I want, rather that how the system stores it, and not get either a bunch of random number (I know there not technically random) or the above.

The code I’m using now is basically

Destination Cell = Source Date/Time Cell & “ “ & Source Time Zone Cell

Use Format to get the result you want like this:

Destination Cell = Source Date/Time Cell & “ “ & Format(Source Time Zone Cell, "m/d/yy h:mm" & " PST")

Hope this helps,
theDude

That's perfect, thank you!