TrippyTom
02-05-2009, 02:13 AM
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?
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?