| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill with zero
Hi,
I table of 3 digit numeric fields, data in field can be 1-3 significant digits. I use the numbers as input to another look up that requires all 3 digits and filled with zeros. So I need a formula to determine number of significant digits in original field and if less than 3 fill to 3 with zeros. I tried "format" as well as "precision as displayed", but niether worked. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill option | New Users to Excel | |||
| Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
| Fill handle formula | Excel Worksheet Functions | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Threaded Mode
