| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add zeros to fill in and
Thanks JoeU2004 this was exactly what I needed. I appreciate your help
"JoeU2004" wrote: "LG" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add zeros to fill in and | Excel Worksheet Functions | |||
| 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) | |||
| 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) | |||
![LG[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
