Thread: Number formate
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Abdul Shakeel Abdul Shakeel is offline
external usenet poster
 
Posts: 39
Default Number formate

But I have in a software could it not possible with help of VBA

"Jim Thomlinson" wrote:

No. The commas will only show up after you have entered the result.
--
HTH...

Jim Thomlinson


"Abdul Shakeel" wrote:

Hi All,

I want to know is there any way that if I write a number e.g. 12,000 so when
I write "12" a currency comma (,) appears automatically and after I type 000
currency comma appears then after & set it place with the number write.