


Here's an alternate method that requires inserting a temporary column to do the conversion, but can be restricted to apply only to the column containing the UPC list. Chrome OS Task description,Shortcut PC,Mac,Chrome OS Common actions Select column,Ctrl+Space,Ctrl+Space,Ctrl+Space Select row,Shift+Space,Shift+Space,Shift+Space Select all,Ctrl+a Ctrl+Shift+Space,+a +Shift+Space,Ctrl+a Undo,Ctrl+z,+z,Ctrl+z Redo,Ctrl+y Ctrl+Shift+z F4,+y +Sh.
#Numbers for mac delete sheet free#
Clicking Replace All, as suggested by Jerry, does exactly that great if the only hyphens in your document are the ones you want to replace, not so great if there are hyphens that are not part of the UPC codes, and that you want to keep. Free customizable iWork school templates for Mac Pages and Numbers including grade books, homework worksheets, report cards, charts, cheat sheets, learnings worksheets, grids, logs, and more.

One difficulty with Find/Replace is that it is All or One-at-a-time.Ĭlicking the Replace and Find button, as suggested by Wayne, can get tedious,if you have a large number of replacements to do (you have three for each entry). You'll need Find and Replace, as already suggested, or a formula, to make that conversion. Custom formatting can be used to display something Numbers interprets as a "number" as a combination of number(s) and text.īut Numbers interprets an entry (as opposed to a display) that contains both numbers and text as a text string, and custom formatting can't be used to display only the numeric characters in that string.
