Is there a simple shortcut key that changes number formats of a selected range to "comma"? Pierre
P Pierre Feb 20, 2009 #1 Is there a simple shortcut key that changes number formats of a selected range to "comma"? Pierre
G Glenn Feb 20, 2009 #2 Pierre said: Is there a simple shortcut key that changes number formats of a selected range to "comma"? Pierre Click to expand... Look at "Keyboard shortcuts" in the help file. Under "Keys for entering, editing, formatting, and calculating data" and "Format data" you will find this (among many other options): CTRL+SHIFT+! Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values.
Pierre said: Is there a simple shortcut key that changes number formats of a selected range to "comma"? Pierre Click to expand... Look at "Keyboard shortcuts" in the help file. Under "Keys for entering, editing, formatting, and calculating data" and "Format data" you will find this (among many other options): CTRL+SHIFT+! Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values.
P Pierre Feb 20, 2009 #3 Look at "Keyboard shortcuts" in the help file. Under "Keys for entering, editing, formatting, and calculating data" and "Format data" you will find this (among many other options): CTRL+SHIFT+! Apply the Number format with two decimal places, thousands separator, andminus sign (–) for negative values. Click to expand... Thank you Glenn. Pierre
Look at "Keyboard shortcuts" in the help file. Under "Keys for entering, editing, formatting, and calculating data" and "Format data" you will find this (among many other options): CTRL+SHIFT+! Apply the Number format with two decimal places, thousands separator, andminus sign (–) for negative values. Click to expand... Thank you Glenn. Pierre