Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to number excel cells automatically
I am using excel Sheet which contains around 1000 cells to be numbered
serially, eg:A1 as X_XX_001_XX A2 as X_XX_002_XXX A3 as X_XX_003_XXXX ... can anyone let me know solution for this... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to number excel cells automatically
In A1:
="X_XX_"&TEXT(ROW(),"000")&"_XX" Copy down as far as needed -- Kind regards, Niek Otten Microsoft MVP - Excel "kkr" wrote in message ... |I am using excel Sheet which contains around 1000 cells to be numbered | serially, | eg:A1 as X_XX_001_XX | A2 as X_XX_002_XXX | A3 as X_XX_003_XXXX ... | can anyone let me know solution for this... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to number excel cells automatically
="X_XX_"&TEXT(ROW(A1),"000")&"_XX"
works for any starting point -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | In A1: | | ="X_XX_"&TEXT(ROW(),"000")&"_XX" | | Copy down as far as needed | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "kkr" wrote in message ... ||I am using excel Sheet which contains around 1000 cells to be numbered || serially, || eg:A1 as X_XX_001_XX || A2 as X_XX_002_XXX || A3 as X_XX_003_XXXX ... || can anyone let me know solution for this... | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically count the number of cells highlighted | Excel Discussion (Misc queries) | |||
how do I automatically number cells | Excel Discussion (Misc queries) | |||
How does excel automatically covert cells when a different number. | Excel Discussion (Misc queries) | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions |