Fusion Pro with Excel - Mail Merges

[TrippyTom]

First, I must say that I don't work in Fusion Pro directly, but I have a coworker that does. I'm not even sure what version he has, but I'm starting to hate the limited capabilities of it because he says it only accepts CSV or TXT files.

Because of this, every time my coworker has to do a mail merge, he always asks me for help because he's not familiar with formulas in Excel at all.

What I've been doing is, if a cell needs a number format, I will write a formula to convert it to TEXT and force it to have a certain look, like this:
=TEXT($A1,"$#,0.00")

But then I have to copy that entire column to another new column as values or the merge won't work.

Is there an easier way? Or is this just what I have to deal with?

[Oorang]

Have you tried exporting the unconverted values to CSV as well as the converted values then opening the file in notepad to see what the difference is? I suspect one will have the values in quotes whilst the other will not.

[TrippyTom]

No, I didn't try that. But you can be sure I will when I get to work!

I'll get back to you on the progress.