shortcut for the accounting format

[Jadegirl]

Does anyone know the shortcut for the accounting number less the dollar sign and decimal placings? The only one ctrl+shift+4 will put $1033.00, but i would like to have 1,033 in accounting format with the comma placing. The reason is that when I have a zero, a - will be inserted instead of a 0. It looks cleaner. Also when I use link cells to another page, it will display a - if nothing is in the cell. This can be when I link a cell w/ words.

Appreciate any input!

 

[Trevor G]

Look at recording a MACRO to set the format and you can then apply your own shortcut key.

The following code sample is a recorded macro to apply the format to any cell. I seelcted a cell before recording, then used Ctrl + 1 to get to Format Cells then selected Number and no Decimals. Then stopped recroding.

Sub Macro1()
'Recorded macro and used Ctrl + Shift + E as capital letter
'
Selection.NumberFormat = "#,##0_ ;[Red]-#,##0 "
End Sub

 

[Jadegirl]

thanks

 

[Babar]

thanks

Salam to Every One,

Brother short Key for Accounting format is available in Excel just try the following one:

Press Alt , H , K

I hope that's the one we're looking for

 

[sreeganeshi]

Thank you very much its really great