View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nik[_2_] Nik[_2_] is offline
external usenet poster
 
Posts: 3
Default Strange 'Print' behaviour'

Tom Ogilvy wrote:
Yes. A space is placed on each end of a number as part of its inherent
formatting.

If you look closely, if you just debug.print a number, it starts in the
second column.

Debug.Print 3 ' starts in second column.

So it does - I hadn't noticed the double space before the number in my
example.

I don't suppose that there is any way to over-ride this that is more
elegant than declaring what should be an integer as a string?

Nik