Decimal Places

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I need to withhold the decimal point without giving up it's place? Can
anyone help?

Ex. 198.22
200.00

Need to be 0000019822
0000020000
 
If you want them to still be numbers, assuming your values are in A2 and
down, type in B2, =A2*100, then go to Format|Cells, Number tab, Custom, and
type in 10 zeroes.

If, however, you are ok with dealing with them as text, you could type the
following formula in B2:
=TEXT(A2*100,"0000000000")
 

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

POSTIVE PAY FILE FORMAT 4
why 2003 excell does not accept dot as decimal points 1
Access stripping decimal places in query 1
changing decimal places according to formula result 6
Removing Decimals and Calculating Prime Number Fields 5
office 2003 Excel - SUM 3
Decimal Place goes crazy when using the "&" Sign. 4
Incorrect result for simple SUM formula 9

Back
Top