ExcelBanter - Formatting of cells

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formatting of cells (https://www.excelbanter.com/excel-worksheet-functions/74102-formatting-cells.html)

Pete

Formatting of cells

All new and old spreadsheets now have a bug. Any typed number (say 5) comes
out as .05 every time. help! Normal change of format using Format / Cell/
Number does not work!

Bob Phillips

Formatting of cells

Menu ToolsOptions and go to the Edit tab.

See if the Fixed Decimal box is checked, if so uncheck it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Pete" wrote in message
...
All new and old spreadsheets now have a bug. Any typed number (say 5)
comes
out as .05 every time. help! Normal change of format using Format / Cell/
Number does not work!

All times are GMT +1. The time now is 11:38 PM.