|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2009, 04:18 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell to always begin with an "X"
Is it possible to format a cell to always add an "X" at the beginning of the
data input in the cell? I imagine it can be done under CellFormatNumberCustom but am wondering exactly what I would have to put as the format. Thanks in advance for your assistance! 
|
|
#2
October 27th, 2009, 04:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell to always begin with an "X"
On Tue, 27 Oct 2009 09:18:11 -0700, Cheri
wrote: Is it possible to format a cell to always add an "X" at the beginning of the data input in the cell? I imagine it can be done under CellFormatNumberCustom but am wondering exactly what I would have to put as the format. Thanks in advance for your assistance! You just preface each section of the format string with an "X" (with or without the quotes). One way would be: xGeneral;x@ --ron
|
|
#3
October 27th, 2009, 05:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell to always begin with an "X"
Try using:
"x"### "Cheri" wrote: Is it possible to format a cell to always add an "X" at the beginning of the data input in the cell? I imagine it can be done under CellFormatNumberCustom but am wondering exactly what I would have to put as the format. Thanks in advance for your assistance!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
