Erika
Do you mean if you type 123 in a cell it comes up as 1.23?
ToolsOptionsEdit. Uncheck "fixed decimal places".
Gord Dibben Excel MVP
On Tue, 11 Jan 2005 06:41:03 -0800, "Erika"
wrote:
When using excel, if a cell format is set to the general format it still
comes up with decimal places. The only way I can get a number without
decimal places is to first enter it as text and then convert to a number.
|