| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Lenny
FormatNumberCustom Enter the appropriate number of 0's 000000.00 Would return 000023.23 or 000002.32 or 000232.32 Gord Dibben Excel MVP On Wed, 15 Dec 2004 09:51:06 -0800, LennyD wrote: I need to generate a spreadsheet column that has a fixed number of digits to the left of the decimal. I need to fill with leading zeroes if number smaller than number of digits. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Why can't I format cells in Excel 2000? | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Hybrid Mode
