Changing display of value with multiple decimal points

**lnardolillo** · 12-16-2010, 05:27 PM

I inherited a list with 2800 records, each identified with 3 decimals. For example. 1.1.2.4 or 1.2.4.23, or 10.15.123.43.

I would like to display the items consistently in the following format ##.##.##.###. So, my first entry above would display as .01.01.02.004.

Is that possible? I have tried many formatting options, but then I realized the 1.1.2.4 is not really a number, because numbers have only one decimal point. Any help is appreciated. i really don't want to enter all 2800 cells again.

Larry

**NBVC** · 12-16-2010, 05:47 PM

There might be a shorter way..but

If you put this formula in an adjacent cell:

Please Login or Register  to view this content.

Where A1 represents first cell to parse.

Then copy down to convert all,

Then you can copy this column and paste special >> Values over your original column and delete the formula column.

**DonkeyOte** · 12-17-2010, 04:17 AM

If by any chance you meant 00.00.000.000 (given the last of your examples has three digits in third sub section) then another alternative might be to convert the original to a number and apply a Custom Format

Assume original values in A1, A2 etc then:

Please Login or Register  to view this content.

However, I suspect the above fails requirements... thought I'd post it just in case.

Changing display of value with multiple decimal points

LinkBack

Thread Tools

Rate This Thread

Display

Changing display of value with multiple decimal points

Re: Changing display of value with multiple decimal points

Re: Changing display of value with multiple decimal points

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions