Deviding numbers

[avw84]

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)

[ChristopherShay]

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

[José Augusto]

You can use the formula

Please Login or Register  to view this content.

for the decimal part
and

Please Login or Register  to view this content.

for the integer part.

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

Best regards

[AlKey]

in B1 and copy down

=TEXT(INT(A1);"00")

in C and copy down

=TEXT(MOD(A1;1)*100;"00")

Row\Col	A	B	C
1	24,50	24	50
2	10,00	10	00
3	19,03	19	03

[avw84]

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?

[avw84]

Thanks a lot AlKey, great job!