Remove decimal from price to show straight number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Need Macro... 8
How to retrieve number of visible digits after decimal point in VBA 5
Trim varying decimals from column of numbers 9
Formatting Decimal Places 3
Remove decimal but keep entire number 5
Excel Number Formatting 1
How to print numbers invariably using dots as decimal symbol? 9

Back
Top