I believe that the appearance of the number is applied by the cell
formatting functions, but the data in the cell is unaltered. Therefore a
text box linked to the cell data will reflect the actual number entered into
the cell, not the formatted appearance.
You could ...
1) Have a VBA routine in PowerPoint that would reformat the textbox within
PowerPoint, but it will need to be triggered by the number updating, which
is difficult. It could also be triggered by slide change, or even manually,
I suppose. It is doable, but not easy.
2) Have excel pre-format the number for you. Instead of linking to a cell
with a number that has been entered (i.e. in cell A1 a "2" was manually
entered by the user, but $2.00 is displayed, because the cells formatting
alters the entered number to show it as a dollar amount), link to a cell
that references and formats the data entry cell (i.e. the formula entered
for cell B1 is set to
=TEXT(A1,"$0.00")
where A1 is the user's data entry cell). This should pre-format the cell
contents for you prior to your importing it into PowerPoint at the expense
of adding a (possibly hidden) column to your worksheet.
Let me know if this does the trick for you.
B
===============
Please spend a few minutes checking out
www.pptfaq.com This link will
answer most of our questions, before you think to ask them.
Change org to com to defuse anti-spam, ant-virus, anti-nuisance
misdirection.
