I'm creating a file that will be sent out to regional offices around the world. We've created a tool that automatically copies pertinent data to a Powerpoint presentation to submit to the corporate office, but I've noticed that all number formats remain in the local currency or date format (like commas replaced by periods and vice-versa for Europe)
Is there a way to tell Excel to display all formats for certain cells in US number formats? I need it to work without changing settings on everyone's machines (as they're located around the world). I've tried using the TEXT formula but have had no success.
The client prefers no VBA but if we have to go that route I'd be willing to do it.
Thank you for any suggestions.
Is there a way to tell Excel to display all formats for certain cells in US number formats? I need it to work without changing settings on everyone's machines (as they're located around the world). I've tried using the TEXT formula but have had no success.
The client prefers no VBA but if we have to go that route I'd be willing to do it.
Thank you for any suggestions.