The macro-recorder does not record what I do! (apparently..)

[plantago]

I want to record a macro. I start recording, marking the cells,
choosing format > cells, use 1000 separator, decimal places: 0, stop
recording.

When I run the macro, the numbers have only one desimal and no
1000-separator, why? (Custom format "#.##0")


Sub Macro4()
'
' Macro4 Macro
' Macro recorded 7/6/2006 by __________________________
'

'
Range("B2:M4").Select
Selection.NumberFormat = "#.##0"
End Sub

 

[Jared Call]

You might try #,##0 instead of #.##0

~Jared