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
|