Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
move the $ signs on Excel spreadsheet to the right (closer to
What about changing the properties of the Currency button so the $ sign
aligns with the currency values? If so, how? Seems it would be fewer clicks if you think about it. "Mike Middleton" wrote: Sharla - Don't use the Currency button on the Formatting tool bar. Instead, choose Format | Cells | Number | Currency ... - Mike http://www.mikemiddleton.com "Sharla" wrote in message ... My spreadsheet looks terrible. The currency signs are left alligned in the excel cells, and I can't get them to move over near my dollar ammounts on the right, even when I try right alligning the cells. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
move the $ signs on Excel spreadsheet to the right (closer to
RhysPieces
Copy this macro into your Personal.xls Sub Curr_Format() Selection.NumberFormat = "$#,##0.00" End Sub Then ToolsCustomize. Right-click the $ Icon and assign the macro to that Icon. Gord Dibben MS Excel MVP On Tue, 24 Oct 2006 14:46:01 -0700, RhysPieces wrote: What about changing the properties of the Currency button so the $ sign aligns with the currency values? If so, how? Seems it would be fewer clicks if you think about it. "Mike Middleton" wrote: Sharla - Don't use the Currency button on the Formatting tool bar. Instead, choose Format | Cells | Number | Currency ... - Mike http://www.mikemiddleton.com "Sharla" wrote in message ... My spreadsheet looks terrible. The currency signs are left alligned in the excel cells, and I can't get them to move over near my dollar ammounts on the right, even when I try right alligning the cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move around an Excel spreadsheet using arrow keys? | Excel Discussion (Misc queries) | |||
Excel Spreadsheet Not Saved Dialog Error | Excel Discussion (Misc queries) | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) |