| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove comma tool bar button
Is there a way to remove commas from the cell contents with a toolbar button.
The comma button will add commas but won't remove them |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove comma tool bar button
Sure, format the cell as General
Tyro "GKW in GA" wrote in message ... Is there a way to remove commas from the cell contents with a toolbar button. The comma button will add commas but won't remove them |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove comma tool bar button
There's no toolbar button that will remove the commas. You can add the
Style box to one of your toolbars, and select the Normal style from that. To add the Style toolbar, right-click on a toolbar, and click on Customize. In the Customize dialog box, click on the Command tab Click on the Format category Drag the Style dropdown box to one of your toolbars. Close the Customize dialog box. Select the cells that you want to format From the Style dropdown, select Normal. GKW in GA wrote: Is there a way to remove commas from the cell contents with a toolbar button. The comma button will add commas but won't remove them -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and remove a string of a cell value with comma as delimiter | Excel Discussion (Misc queries) | |||
| need to remove a comma from end of test in cells | Excel Worksheet Functions | |||
| Comma format button decimals | Excel Discussion (Misc queries) | |||
| How to remove comma and decimals from a value | Excel Discussion (Misc queries) | |||
| Formatting inconsistencies using the comma button | Excel Discussion (Misc queries) | |||
Linear Mode
