Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding prefix to cell entries
I have some tags that are numbered from
982 00000000 to 982 00000300 I tried using the cell fomat "982 00000"@ to allow me just type in the part that is changing (IE 0 to 300) for ease of use and less errors. My trouble is this doesn't force the extra 0's for tag numbers below 100. Can I do this as it is not a number because of the space. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding prefix to cell entries
How about a custom format of:
"982 "00000000 NDBC wrote: I have some tags that are numbered from 982 00000000 to 982 00000300 I tried using the cell fomat "982 00000"@ to allow me just type in the part that is changing (IE 0 to 300) for ease of use and less errors. My trouble is this doesn't force the extra 0's for tag numbers below 100. Can I do this as it is not a number because of the space. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding prefix to cell entries
Thanks Dave. Worked a treat. I had tried that before on a cell that already
had a number in it and the number didn't change so I thought it didn't work. If I format the cell first and then type the number in it works fine, so I've learnt two things. Thank you "Dave Peterson" wrote: How about a custom format of: "982 "00000000 NDBC wrote: I have some tags that are numbered from 982 00000000 to 982 00000300 I tried using the cell fomat "982 00000"@ to allow me just type in the part that is changing (IE 0 to 300) for ease of use and less errors. My trouble is this doesn't force the extra 0's for tag numbers below 100. Can I do this as it is not a number because of the space. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding prefix to cell entries
If that value was a real number, then it shouldn't matter the order.
But I bet you entered the value as text (leading apostrophe or preformatted the cell as text???). Then changed to that custom format. ps. A quick way to "reenter" the value is to select the cell, hit F2 (to edit) and then Enter to finish the edit. NDBC wrote: Thanks Dave. Worked a treat. I had tried that before on a cell that already had a number in it and the number didn't change so I thought it didn't work. If I format the cell first and then type the number in it works fine, so I've learnt two things. Thank you "Dave Peterson" wrote: How about a custom format of: "982 "00000000 NDBC wrote: I have some tags that are numbered from 982 00000000 to 982 00000300 I tried using the cell fomat "982 00000"@ to allow me just type in the part that is changing (IE 0 to 300) for ease of use and less errors. My trouble is this doesn't force the extra 0's for tag numbers below 100. Can I do this as it is not a number because of the space. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Prefix | Excel Worksheet Functions | |||
adding a prefix to cells | Excel Discussion (Misc queries) | |||
Adding a prefix to all numbers in a column. | Excel Discussion (Misc queries) | |||
Adding zero prefix to no's | Excel Discussion (Misc queries) | |||
Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) |