VB Code to change format, save in notepad file

Hello:

Please refer to attached file.
I have data in excel sheet as shown in column K
I need VB Code to go thru each row of data and do the following:
1. Go thru each cell in column K and if it finds numeric number then format that number to 2 decimal places
For example K26 has value 14, change the format so that it displays 14.00

2. Go thru each cell in column K and if it finds numeric negative value then add "$" in front of
numeric number..
Example K7 is -232.15, change to $-232.15

3. Copy column K into notepad file and save as C:\Temp\Test.qif

Let me know if you have any questions.
Thanks.

Riz

Hi AlphaFrog and Leith:

Code works good, need small modification.

Go thru each cell in column K and if it finds numeric positive value then add "$" in front of
numeric number..
Example K29 is 14.39, change to $14.39

Also the location and file name to be saved as QIF will be in Cell L1 so pick up from here

Please let me know if you have any questions.
Thanks.

Riz