decimals removed but all values remain

[ianjwerner]

I am working with a program where I need someone to enter the amount $100.00 but when inputting the amount for data entry $100.00 = 10000
Is there a formula that can be used to convert what is needed for input into another cell?

 

[Joe4]

Just multiply by 100 and format as a number with 0 decimals, i.e.

=E2*100

 

[synergy16]

just format that destination column as a general and multiply each cell by 100

 

[ianjwerner]

good idea! thanks!

 

[Joe4]

You are welcome.
Glad we were able to help!