Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format
If I have a cell that contains text: 0012222 and I wish to apply custom
formatting to it like this: ###-#### I would expect the cell to look like this: 001-2222 but if the text is already in the cell the view of the cell does not change. But if I blank the cell out and then type 0012222 it appears as 001-2222. Any idea why this is and how do I get around it so I can format cells that are already containing data? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format
If the entry was made when the cell was formatted as text, then the value in
that cell is still text after you changed to the custom format. And text values won't use this custom number format. One way to fix this is to select an empty cell edit|copy Select the range of offending cells edit|paste special|check Add and values Mike H. wrote: If I have a cell that contains text: 0012222 and I wish to apply custom formatting to it like this: ###-#### I would expect the cell to look like this: 001-2222 but if the text is already in the cell the view of the cell does not change. But if I blank the cell out and then type 0012222 it appears as 001-2222. Any idea why this is and how do I get around it so I can format cells that are already containing data? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format
Hi Mike,
In the back of your mind, you're probably pretty clear on how it works, but to be more specific. Changing the format between text and number in either direction has no effect on the existing formatting of the cell until the data in the cell is reentered. The simplest way to reenter same data for a single cell is to use F2 then Enter. A single quote in front of data will override formatting and will be a text entry. Changing the format of a cell actually formatted as numeric (not as text) to another number format will be effective immediately. You may find items of additional interest at http://www.mvps.org/dmcritchie/excel/formula.htm http://www.mvps.org/dmcritchie/excel...tm#debugformat and the topic below that as well (#reenter) on reentering. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Mike H." wrote in message ... If I have a cell that contains text: 0012222 and I wish to apply custom formatting to it like this: ###-#### I would expect the cell to look like this: 001-2222 but if the text is already in the cell the view of the cell does not change. But if I blank the cell out and then type 0012222 it appears as 001-2222. Any idea why this is and how do I get around it so I can format cells that are already containing data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
Custom format | Excel Discussion (Misc queries) | |||
custom format or conditional format? | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions |