How do I copy formatted values and paste without formatting?!

[Rancho_001]

I have a date/time stamp column that is formatted as (ddmmyyyy hh:mm:ss AM/PM). The big picture is that I am trying to convert this data so that it can be counted and plotted. Where I am stuck is after reformatting this field into only the military hour, I cannot copy and paste that value into another cell without the formatting being pasted as well.

For example, after pasting, my formatted value might be 1700 but the actual value is "11/29/2013 5:29:29 PM"

I need the formatted 1700 to be actually "1700" so I can count the number that hour occurs in my string.

please help!!!

 

[mcwillis81]

Hi,

Rather than copy and paste could you link back to the cell with the text function as below

=TEXT(a1,"hhmm")

This converts the value to text and allows you to choose the format.