| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating numbers
i have a huge list of numbers that appear as, for example 12345-1, but would
like to change them so they appear as 0012345-001. help please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formating numbers
If your value is in cell A1, then in another cell enter:
="00" & LEFT(A1,6) & "00" & RIGHT(A1,1) and you will have your desired result. -- Gary's Student "Daveed" wrote: i have a huge list of numbers that appear as, for example 12345-1, but would like to change them so they appear as 0012345-001. help please |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formating numbers
You have a few replies at your other post in .excel.
Daveed wrote: i have a huge list of numbers that appear as, for example 12345-1, but would like to change them so they appear as 0012345-001. help please -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formating numbers | Excel Discussion (Misc queries) | |||
| numbers formating problem | Excel Discussion (Misc queries) | |||
| formating negative numbers | Excel Discussion (Misc queries) | |||
| formating numbers | Excel Discussion (Misc queries) | |||
| formating numbers | Excel Discussion (Misc queries) | |||
Linear Mode
