Addition of dots between various numbers

[Vibhav]

HI

I want to add dot between the digits of the numbers in my worksheet
i want to add a dot between 123 i.e. make it 1.2.3 in my workbook, i have different numbers in every row for eg 912, 813 etc want to make them 9.1.2, 8.1.3 etc...kindly help
Thanks

[Sisyphus]

Hi,
You can do that with the cell format (Format/Cells - Number tab / Custom).
Write this in the 'Type' field:

Code: Select all

0\.0\.0

This format works fine with numbers of exactly 3 digits. a zero will be shown in place of missing digits. If your number has more than 3 digits the extra digits will be shown before the first period. Replacing 0 with # will avoid showing zeros in place of missing digits, but there is no way to prevent as many periods from being written as the format holds, regardless of how many digits your number has.
I hope this can meet your requirement.