I am doing a macro to extract data from workbook1 to workbook2 and need
to make:

- String value on a specific column fit into 3 characters in the
destination file. I have about 70 column like this with different
character size.
- Number value with a total of "6.2 decimal" in the destination
file. I think this means 2 decimals.

The problem: I only know how use the button "record a macro" but did
not find the "string" and "decimal" thing in the cell format
menu/option.

If anyone could help out, I would really appreciate it. Once I learn
how to work on 1 column, I can do the rest. Thank you in advance. James