Formatting cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet in which some cells are placing a decimal point in the numbers we enter. I think the cell thinks we are entering dollar amounts. I right click on the cell and choose format cell and on the Number Tab the Category Field is marked General and to the right it says "General format cells have no specifc number format". However in the sample box is shows 283802.07, it is placing a decimal point anyway. Any ideas on how to fix this? I just need to enter the numbers without a decimal point

Thanks

Anthony
 
The box is unchecked. Any other ideas or did something just become corrupt.

Anthony

----- J.E. McGimpsey wrote: -----

Tools/Options/Edit uncheck the Fixed decimal places checkbox.
 
Change the Cell format to "Text", It should work.
-----Original Message-----
I have a spreadsheet in which some cells are placing a
Click to expand...
decimal point in the numbers we enter. I think the cell
thinks we are entering dollar amounts. I right click on
the cell and choose format cell and on the Number Tab the
Category Field is marked General and to the right it
says "General format cells have no specifc number format".
However in the sample box is shows 283802.07, it is
placing a decimal point anyway. Any ideas on how to fix
this? I just need to enter the numbers without a decimal
point.
 
Format the range of cells in question to 0 decimal places.
- Select range of cells
- <Format><Cell>
- select "Number"
- enter "0" for Number of Decimal Places
 
Back
Top