Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 sergio0592
		
			sergio0592
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi all,
I'd like format my expression number with separation between thousands . In the chart properties, it works when i put # ##0
But i try to get the same thing with num function, it goes wrong. I try with =num(sum(Orders),# ##0) and i have the message 'Error in expression'.
Regards
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 robert_mika
		
			robert_mika
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=num(sum(Orders),'# ##0')
You need apostrophes..
 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		try to add single quotes for
'##0'
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this:
=Num(Sum(Orders), '# ##0', '.', ' ')
 
					
				
		
 sergio0592
		
			sergio0592
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Great Sunny, as usual  !! Solutions suggested by Chanty and Robert return : Number # ##0
!! Solutions suggested by Chanty and Robert return : Number # ##0
I will work on num function, it seems have numerous parameters!
