Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make repeat long numbers shortcut ?
Anybody knows how to make repeat long numbers shortcut ? Instead of
input repeat long numbers, can I make a shortcut ? Example : A1 = 4895028 A2 = 5904311 A3 = 8953261 A4 = 5904311 (repeat) A5 = 4895028 (repeat) And so on... Thank You. |
#2
|
|||
|
|||
If first number is in A1 and you what a repeat in say A10; type = and click
on A10. To later convert all to numbers, Copy and then Paste Special | Values OR enter a4895028 and b5904311, etc, using new letter fro each new number now when you type a, Excel will autocomplete to give a4895028 later use =VALUE(MID(A1,2,LEN(A1))) and the Copy/paste special to convert best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "toyota58" wrote in message oups.com... Anybody knows how to make repeat long numbers shortcut ? Instead of input repeat long numbers, can I make a shortcut ? Example : A1 = 4895028 A2 = 5904311 A3 = 8953261 A4 = 5904311 (repeat) A5 = 4895028 (repeat) And so on... Thank You. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a list of consecutive numbers in a column? | Excel Worksheet Functions | |||
How do I make the custom headers and footer repeat on every works. | Excel Worksheet Functions | |||
how i can make the numbers | Excel Discussion (Misc queries) | |||
How to make [toggling] shortcut keys to superscript and subscript, respectively? | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |