Benches Uncategorized

2

Paste and Match Style not converting text to cu...

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Hi,

Please check me out on this. I have a table of text values that I've picked up from a PDF statement where the currency values don't have dollar signs and are mixed in with other data types. I don't want to format individual entries, so I thought I'd copy an entire record as text values and then Paste and Match Style into a pre-formatted table to fix all the formats at once.

I find that text-formatted xxxx.xx doesn't convert to $x,xxx.xx when I paste and Match Style into a cell formatted as currency. Here's a screen shot that shows that the Format Bar recognizes the pasted content to be currency, as does the Cells Inspector, but the Formula Bar doesn't show the conversion and the cell display doesn't show the conversion.

Similarly, doing a Paste and Match Style into a cell formatted as Number with 4 decimals also fails to convert the number of decimal places, but shows the desired format in the Inspector.

Both conversions work in iWork 08.

Anyone else seeing this?

Jerry

2 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi Jerrold

    As far as I know you are trying to apply a format with a tool which is designed to set a value and a style so, it doesn't do what you wish.
    It doesn't do that on my machine too.

    What is bothering me is why are you getting a string after a copy/paste from a PDF.

    My guess is that there was extraneous characters embedded.

    Yvan KOENIG (from FRANCE lundi 6 avril 2009 23:23:01)

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yvan,

    Thanks for checking this. Try it in iWork 08 if you get an chance.

    Jerry