ExcelBanter - .xls Cell Format

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - .xls Cell Format (https://www.excelbanter.com/charts-charting-excel/133168-xls-cell-format.html)

Stoehr

.xls Cell Format

In the last couple off weeks, a change? has caused CellFormatgeneral to
default to 2 decimals. Cannot be changed. What has happened. How to fix.
'Text' format not an option.

John

.xls Cell Format

Check toolsoptionsEdit tab and uncheck fixed decimals
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"Stoehr" wrote:

In the last couple off weeks, a change? has caused CellFormatgeneral to
default to 2 decimals. Cannot be changed. What has happened. How to fix.
'Text' format not an option.

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