View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Decimal Points in cells

Simply type the number and hit Enter.

If you're getting something like this...

You enter 45 in a cell it converts to 0.45...

Goto the menu ToolsOptionsEdit tabuncheck: Fixed decimal placesOK out

If you're getting something like this...

You enter 45 in a cell and it converts to 45.00...

Select the cell(s) in question
Goto the menu FormatCellsNumber tabchange the format to either General
(preferred) or Number and set the decimal places to 0OK out

--
Biff
Microsoft Excel MVP


"Wayward" wrote in message
...
Can someone please guide me to a means of placing numbers in cells without
decimal points? I want to build a spreadsheet to track miles.

Thanks in advance, Wayward