Format command
 

Hi

Has anyone used the command Format(variable,"!"), not sure what the ! stands
for ?

Thanks
ailish

Format command
 

From VBA Help:

User-Defined String Formats (Format Function)

! Force left to right fill of placeholders. The default is to fill
placeholders from right to left.



In article ,
Ailish wrote:

Hi

Has anyone used the command Format(variable,"!"), not sure what the ! stands
for ?

Thanks
ailish