Thread: Format Number as Arabic (Saudi Arabai) inside text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abdul[_2_] Abdul[_2_] is offline
external usenet poster
  
Posts: 137
Default Format Number as Arabic (Saudi Arabai) inside text
Hello!

How I can format a number with a text

Range("A2") .NumberFormat = "[$-2000000]#0,000.00"

If I want " this number is 2000" then

something like
Range("A2") ="This number is " & format(2000, "[$-2000000]#0,000.00")

Thanks

Reply With QuoteReply With Quote