Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Format command

Hi

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

Thanks
ailish
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nesting the ROW() command into a Conditional Format Formula ahalford Excel Worksheet Functions 4 November 6th 08 06:00 PM
Format the command for the Currency button Murray[_3_] Excel Discussion (Misc queries) 4 July 30th 08 08:37 PM
Format Cell command will not function Phil Excel Discussion (Misc queries) 1 January 24th 08 03:47 PM
DDE Command to Format Cell Lynn Schauer Excel Programming 1 July 11th 03 02:10 PM
DDE Command to Format Cell jaf Excel Programming 1 July 9th 03 05:10 PM


All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"