| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add zeros to fill in and
You could use:
=G5&" "&A7&" "&B7&" "&text(g7,"0000000000")&F7&" "&F5 or =G5&" "&A7&" "&B7&" "&text(g7,rept("0",10)&F7&rept(" ",23)&F5 Ps. You don't need &""& Using =rept() makes it easier to see things (for me anyway). LG wrote: Below is the information I have cell G5 = $PAAY3 cell A7 = ABC cell B7 = 20090810058 cell G7= 0000000000 cell F7= 16833 cell F5= LG The top is the formula I have complete the bottom is what I need it to show as =G5&" "&A7&" "&B7&" "&G7&""&F7&" "&F5 $PAAY3 ABC 20090810058 0000016833 LG I need to be able to get the zeros in G7 to fill in the #s from F7 in the final product while deleting the zeros from G7 that is used can anyone help. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| Charting zeros as non zeros | Charts and Charting in Excel | |||
| How do I make a number have leading zeros to fill width of cell? | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
