info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Excel Data Object Question
0 views
Skip to first unread message
Stefanie
Jan 25, 2006, 8:34:13 PM1/25/06
to
Hello! I have a data object with a number that I would like to have show as
currency in NOF MX. I have formatted it in Excel as both TEXT and a CUSTOM
setting both of which read as zero's. The only way I get the true value to
come thru is by leaving it set to number in Excel which looks like this:
359000 but what I really want it to show is $ 359,000.
currency in NOF MX. I have formatted it in Excel as both TEXT and a CUSTOM
setting both of which read as zero's. The only way I get the true value to
come thru is by leaving it set to number in Excel which looks like this:
359000 but what I really want it to show is $ 359,000.
Does anyone know a trick to make this work? I would appreciate your help
greatly!
Stefanie
0 new messages