Deviding numbers

Dear People,

How can I easily devide a list of numbers over two columns without losing the "0".

For example:

24,50 column B: 24 / column C: 50 (instead of 5)
10,00 column B: 10 / column C: 00 (instead of 0)
19,03 column B: 19 / column C: 03 (instead of 3)

Using Text to Columns - you define each column as "Text" after the conversion -
Column A
24,50
10,00
19,03

Selecting column A - then Data Tab - Text to Columns - Delimited -> Next - Delimiters = Comma (check box) -> Next - Set Destination for output - Select each column in Data Preview - specify Text - when done selecting the columns -> Finish.

Regards,

Christopher Shay

Thanks a lot AlKey, great job!

You can use the formula

 =MOD(A2,1)

for the decimal part
and

=INT(A2)

for the integer part.

Use the "0#,00" format in both results

Best regards

ChristopherShay

This is the result I get

24,50 column B: 24 / column C: 5 (instead of 50)
10,00 column B: 10 / column C: (instead of 00)
19,03 column B: 19 / column C: 03 (OK)

Could you please tell me what I am doning wrong?