Format Numbers from an Excel Spreadsheet

J

Janpal

I am bringing data from and excel spreadsheet into visio to create an
organization chart. I am including the base pay in the organizaiton chart.
The salary data comes over unformated. Is there a way to format the data so
it lloks like an annual salary; e.g. $50,000 (rather than 50000.102304).
I have the smae issue with a percent. The percent comes over with all of its
decimlas; e.g. 100.5% looks like 1.0054351. With a a percent I can't even
make a manual change to get the value to look the way I want.
I have searched and searched and can't find a solution. Is there one?? Help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top