Thread: Number formate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Number formate

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.