Convert column from kilobyte to gigabyte and terabyte

[hackery]

I am looking for the easy way to convert an entire column filled with kilobytes into gigabytes and terrabytes? I am using excel 2007 and would like to update this excel workbook in the future by copying/pasting new kilobyte values into the columns and have them automatically converted to giga/terrabytes. Here is an example of columns containing the values. Thanks in advanced for your help