| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format
I have to enter a nine digt number followed by -001. For example
123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format
Hi,
custom format and enter #,0.-001 "Gilbert" wrote: I have to enter a nine digt number followed by -001. For example 123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format
General"-001"
-- David Biddulph "Gilbert" wrote in message ... I have to enter a nine digt number followed by -001. For example 123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format
Thanks Eduardo. But I was hoping not to have the decimal.
"Eduardo" wrote: Hi, custom format and enter #,0.-001 "Gilbert" wrote: I have to enter a nine digt number followed by -001. For example 123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format
Hi
use #,##0"-001" "Gilbert" wrote: Thanks Eduardo. But I was hoping not to have the decimal. "Eduardo" wrote: Hi, custom format and enter #,0.-001 "Gilbert" wrote: I have to enter a nine digt number followed by -001. For example 123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format
0"-001",
or General"-001" as I suggested earlier. -- David Biddulph "Gilbert" wrote in message ... Thanks Eduardo. But I was hoping not to have the decimal. "Eduardo" wrote: Hi, custom format and enter #,0.-001 "Gilbert" wrote: I have to enter a nine digt number followed by -001. For example 123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format
Thanks Eduardo. That's exactly what I was looking for.
"Eduardo" wrote: Hi use #,##0"-001" "Gilbert" wrote: Thanks Eduardo. But I was hoping not to have the decimal. "Eduardo" wrote: Hi, custom format and enter #,0.-001 "Gilbert" wrote: I have to enter a nine digt number followed by -001. For example 123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format
Thank you David.
"David Biddulph" wrote: General"-001" -- David Biddulph "Gilbert" wrote in message ... I have to enter a nine digt number followed by -001. For example 123456789-001. How can I format the cell so that I don't have to enter -001 since it's constant? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
