Paste and Match Style not converting text to cu...
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.
- 0
- 0
