| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal place formatting
My accounts spreadsheet defaults to "£.99" if I enter "99" even though it
should read "£99.00". How can this be fixed when the usual Format-Currency-£ and two decimal places is chosen? Is it something to do with master settings or templates or something? TIA Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Place Rounding | Excel Worksheet Functions | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| changing to two place decimal | Excel Worksheet Functions | |||
| Custom formatting to force a decimal place | Excel Discussion (Misc queries) | |||
Threaded Mode
