How do I convert numbers stored as numbers to text quickly? I'm trying to add
in an extra 0 so that I can mail merge amounts e.g the cells (and formula
bar) say 2.1 and I need it to say 2.10. I've tried formatting the cells to
number, text, general e.t.c but it still stays the same in the formula bar
which means that's how it comes out in when it's been merged. I have about
1000 numbers I'll need to change by hand if I can't find out how this is
done.......please help!