I am sure I am doing something incredibly stupid here but just cant seem to
figure this out.

I have a budget work sheet. The first column is the account number. the
next twelve columns are each month's budget (Jan-Dec). In the original
budget file, some numbers were simply keyed in and others are formulas.
(Some are a gross # times a percentage and others a gross # divided by 12
months).

I am creating a text file to import the budget data into my financial
system.

The first thing I did was to take the budget file and copy it into its own
file by using paste special - values and formats. my number formats are all
##### with no decimals.

This worked perfectly for those #s that were hard keyed in. The ones that
are from formulas - while visually they look like they are formatted #####,
if you are sitting on the cell, it actually is formatted #####.#########.

I need to concatenate all the columns into one cell with a comma separating
each value. The numbers cannot contain any decimals but I cannot seem to get
rid of them. I have tried everything.

Can someone help? thanks.!