| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with numbers in Excel-Specify # of digits
I have a range of numbers; some are 7 digits long, others, 8, 9 or 10 digits.
How can I tell Excel to put zeroes in front of the numbers that don't have full ten digits? I want the result to be ten digits long for everything. Excel 2003. Hopefully this is an easy one for most! Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does excel round off numbers greater than 16 digits? | Excel Discussion (Misc queries) | |||
| Why does excel turn numbers larger than 15 digits to zero? | Excel Discussion (Misc queries) | |||
| How do I keep Excel from dropping my numbers to 0 after 15 digits | Setting up and Configuration of Excel | |||
| in excel, how to limit digits of negative hexadecimal numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
