ExcelBanter - Number formate

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Number formate (https://www.excelbanter.com/excel-discussion-misc-queries/178184-number-formate.html)

Abdul Shakeel

Number formate

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.

Jim Thomlinson

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.

Abdul Shakeel

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.

All times are GMT +1. The time now is 10:28 PM.