| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove decimal from price to show straight number
Hello
I need to remove the decimals from a column of prices so that only the number will be displayed. Example from 0.23 to 023, from 1,000.65 to 100065 Are ther any excel functions or furmulae that will do this without using a macro. Thanks Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert bond price to decimal including + | Excel Worksheet Functions | |||
| Remove decimal but keep entire number | Excel Discussion (Misc queries) | |||
| conditional format of number? -- show decimal ONLY IF not 0 | Excel Discussion (Misc queries) | |||
| Show decimal point only if not a whole number | Excel Discussion (Misc queries) | |||
| how to remove side number that show on the excel worksheet? | New Users to Excel | |||
Threaded Mode
