View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.