Custom number format

[eirikdaude]

Can someone give me a pointer as to why my custom number format only shows 1 decimal place? The number format is

_-* # ##0,000_-;-* # ##0,000_-;_-* "-"??_-;_-@_-

And I ran this snippet on the range to make sure it's all numbers...

Sub dlæøphkæl()
    Dim c As Range
    
    For Each c In ActiveSheet.Range("S34:AD34")
        c.Value = CDbl(Trim(c.Value))
    Next c
End Sub

 

[James006]

Hi,

To understand the specifics of the Four sections ... see

Custom Number Format Guide

Hope this will help

 

[RoryA]

Given the cell alignment, those must be text.

 

[eirikdaude]

Given the cell alignment, those must be text.

Yeah, and for the life of me I can't seem to be able to transform them into numbers, not even when typing a different number into the cell. Anyway, it's not all that big of a deal, those are primarily historic data and I can use the numbervalue-function to transform them to numbers the other places in the spreadsheet where they are used. Thanks for the reply!