| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
format cell for figures - Ajit
1. How can I format a cell or range of cells so that the actual figure I
entered will get automaticall converted in lakhs e.g. the actual figure 64646587.646664 entered in A1 cell should convert in lakhs as 6464.6587646664. 2. How can I make Excel to move along the cell A1, A2, A3 (press Enter button)then B1, B2, B3 (press Enter button) then C1,C2, C3 and so on.. Ajit -- Knowldege is Power |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
