| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time in Number Formate | Excel Discussion (Misc queries) | |||
| Convert text number to number formate | Excel Discussion (Misc queries) | |||
| Formate colour of cells | Excel Discussion (Misc queries) | |||
| No Auto date formate | Excel Discussion (Misc queries) | |||
| cell formate | Excel Discussion (Misc queries) | |||
Linear Mode
