change 5523.44 to 552344 no decimals

  • Thread starter Thread starter Guest
  • Start date Start date
Put 100 in an empty cell, copy it, select the numbers and do edit>paste
special and select multiply

this assumes you have 2 decimals for all your entries
 
I was aware of multipling it by 100 but I was hoping that there was an easier
way other than adding columns. I was looking more for a custom format for
cells if there is one.
 
select the column that has the values
Press Ctrl H
Find what . (decimal - do not type the word decimal just put a decimal
".")
replace with - (leave this blank)
replace all

this will remove all your decimals from that column
 
Can you show me where I said you should add columns? This will change the
values in the existing columns. If indeed you want to convert 100.00 to 10000
and you are using a number format with 2 decimals then the other method
posted using replace won't work for the entries with no decimals like 100.00
or 10.00

Regards,

Peo Sjoblom
 
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

Convert Decimal fractions to binary and vice versa 1
Access stripping decimal places in query 1
Change number from multiple decimals to 2 3
Addition errors with Decimal Places 5
Decimal point in general format 1
need some columns to auto add decimal pt & others to not - How to. 2
Decimal 5
problem with number format with 2 decimals? 5

Back
Top