Customize number format

Hi,
I'm trying to customize an integer to decimal, by formatting cells / column.

Example: -725489639 to -7,25489639 and 388648957 to 38,8648957

I have tried this ""0","00000000000000"" and ""00","00000000000000"" , but not always i have the same count of decimal numbers. the only fix numbers are the first one on longitude and the two first numbers on latitude.

Someone can help me

Thanks

When I was first learning Excel, this was one of my most frequently referenced help files: https://support.microsoft.com/en-us/...7-9c9354dd99f5

If I understand your question, we may be able to take advantage of the limited conditional formatting options available in custom number formats. If your numbers will always be "larger" than 1E13, we could include two conditions in our custom number format

Please Login or Register  to view this content.

This works for up to three conditions, but will not allow more flexibility beyond that.

When you say that you want to do this using formatting only, will you consider using conditional formatting? Excel's conditional formatting feature allows for much more complex formatting decisions. The concept is the same -- build a series of conditions based on the value of the number that assigns the appropriate number format code for the numbers magnitude. If you are unfamiliar with conditional formatting: https://www.excel-easy.com/data-****...ormatting.html

The OP's examples are for Portugal only and are all 14 or 15 digit integers. You are correct that one could possibly need to handle all kinds of scenarios. Custom number formats can handle up to 3 conditions, so, if the OP's requirements are limited enough that he/she only needs up to three conditions to adequately describe his/her need, then custom number formatting can work.

Regular conditional formatting, on the other hand, seems relatively unlimited. Other than it being a bit unwieldy, I see no reason one couldn't test for positive and negative numbers from 1 to 15 digits and any other special considerations.

That said, rather than use formatting for something like, I would prefer a solution like rio.south proposed -- convert the integer to its actual decimal degree value rather than use formatting to make it look like a decimal degree value (but it is still a long integer behind the formatting). But the OP says he/she does not want the actual decimal degree value -- just wants it to look like a decimal degree value.