ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Remove comma tool bar button (https://www.excelbanter.com/excel-discussion-misc-queries/180936-remove-comma-tool-bar-button.html)

GKW in GA

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

Tyro[_2_]

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




Debra Dalgleish

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



All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com