| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove decimal from price to show straight number
Hi Phil,
Not too elegant but you could use text to columns with the period (.) being the delimiter and then concatenate the two in another cell. If needed you can get rid of any (,) commas also. I'm sure there may be a better way, seems there always is....:) Don "AuthorizedUserPF" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
