Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Points in cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Points in cells
I have a similar isssue, except I'm trying to type a fraction and it get
changed to a decimal. I'm using Excel 2007. I don't have (or can't find) a Tools heading to click on. I've tried to format the cells by clicking on either "General" or "Fraction", but it doesn't help. What can I do to be able to write a fraction and have it show in a cell? Thanks, Don "T. Valko" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Points | New Users to Excel | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
Decimal Points | Excel Worksheet Functions | |||
division and decimal points | Excel Worksheet Functions |