Decimal Places

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
 
J

John C

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
How to count the numbers in a Word document? 0
Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
changing decimal places according to formula result 6
why 2003 excell does not accept dot as decimal points 1
Converting decimal degrees to degrees, minutes & seconds 2
Decimal Place goes crazy when using the "&" Sign. 4

Top