Time conversion to General format

[kyddrivers]

I am in need of converting an existing column of data from the exported format of 3/3/2014 9:00:00 AM to 0900 in general format

Example

3/3/2014 9:00:00 AM	0900
3/3/2014 6:00:00 PM	1800

<tbody>
</tbody>

and so on and so forth...

Thanks for the help!!!

 

[BrianMH]

Use the text formula.

=TEXT(A1,"HHMM")

 

[kyddrivers]

Nice and Easy!!

Thanks for the help!!