| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem with number format with 2 decimals?
I have an Excel 2007 spreadsheet for mileage & fuel gallons on the same
worksheet. Mileage is formatted as a whole number. Fuel gallons I want formatted with 2 decimal places. I do not want to enter the decimal point. I can set the worksheet to "automatic insert a decimal point" to 2 places, but it overides the format for the mileage as a whole number. If I turn off "automatic insert a decimal point", I have to manually insert a decimal point. Ex: Mileage Gallons Driver 3500 Truck 1 125.12 Any suggestions? -- Brenda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format Problem | Excel Discussion (Misc queries) | |||
| Custom number format problem | Excel Worksheet Functions | |||
| How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
| number format problem when using =A1&A2 formula | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Threaded Mode
