excel paste not working excel for mac 15

I copy this column.

Paste Special Values.

Then Click on the star icon in the lower left part of the contributors post and add Reputation.

If you are satisfied with the help you have received, then Please do Mark your thread SOLVED.

Just paste, and then Paste Values while the range is highlighted.

PASTE ICON PASTE (while cell still selected) PASTE ICON PASTE VALUE or b.

RIGHT CLICK PASTE SPECIAL VALUES doesnt work.

YEARS it has) same exact way.

I put in a number in a cell 1230456, then went to format cell and custom and typed in 000000000000 then hit ok and it converted the cell to 000001230456 then I copied that cell and paste special into another cell and I got 1230456 but when I changed the destination cell to format - text (it was general) it put it in as 000001230456.

It is funny that I opened your spreadsheet on the same platform as mine and my spreadsheet works but yours doesnt.

But my original text formula did work, even though you noted you wanted the issue fixed.

Good Luck, Ill watch to see if somebody comes up with a solution.

I have Formatted columns B and D to your Custum Format down to Row 10000, and now it accepts the CopyPaste Values.

Also see the Please consider note at the bottom of this post.

But if you copied the unformatted numbers and tried to choose another cell in the general area - right click, paste-special values and number formats, it wont result to the required custum Format as what should be the desired outcome.

Hope that clarifies it a little, since it is almost 1:30am here, and LONG past my nap.LOL Till later my friend.

Ill try to check out your example file tomorrow at work.(I could be reading things wrong.

If you want to Copy a Formatted Cell with its value, you may just simply Copy and Paste, and the leading zeros will display in the new destination Cell.

By default Excel always strips away any leading zeros, from a Number or Text in the Formula Bar.

Also no need to pre-format any destination Cells, when you are Copying from an already Formatted Cells.

I was trying to concatenate the formatted value (ie: w leadign 0s) to another colum or (hard coded) string value.

I concatenate the original value with leading 000s.

You do keep me on my toes with your sharp observations, and I do appreciate it.

Excel Paste Not Working Excel For Mac 15