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

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