M
Minitman
Greetings,
A while back I was looking to change the cell value formatted as
"000xxx00" to be "Map 000X <XX-00>" this finale formatted value to be
copied in this new format to the CustInfo record sheet. After much
discussion, a solution was achieved.
But now I need to keep the original (000xxx00) format and only view
the custom format in both a cell and a UserForm TextBox.
For the sheet cell format, I tried these custom formats in the format
"Map" ???X "<" XX-??">"
"Map" #### "<" ##-##">"
"Map "&####&" <"&##&"-"&##&">"
"Map " & #### & " <" & ## & "-" & ## & ">"
"Map "####" <"##"-"##">"
"Map" #### <##-##>
">!Map "0000 "\<"00-00"\>"
">!Map @@@@ \<@@-@@\>"
None of these work.
One other thing, the cell gets it's value from either this Offset
formula:
=IF(OFFSET(clStart,pfDisc,23)=0,"",OFFSET(clStart,pfDisc,23))
clStart is the reference row (A1 on CustList).
pfDisc is the row in the CustList sheet to be looked at.
23 is the column on that row where to data to be displayed is sitting.
Or direct entry in the edit mode which happens when this cell is
copied and pasted over itself with Edit>Paste special>Values, edited
copied back over to the CustList sheet as a new record and then the
formula is pasted back into the cell, There is some protection turned
off, on, off and back on also in the mix, but that should not be a
factor (I hope).
Anyone have any ideas to how to see Map 123A <BC-45> in a cell with
the cell value of 123abc45?
Any help, suggestions or direction would be appreciated.
-Minitman
A while back I was looking to change the cell value formatted as
"000xxx00" to be "Map 000X <XX-00>" this finale formatted value to be
copied in this new format to the CustInfo record sheet. After much
discussion, a solution was achieved.
But now I need to keep the original (000xxx00) format and only view
the custom format in both a cell and a UserForm TextBox.
For the sheet cell format, I tried these custom formats in the format
number menu:
"Map" ???X "<" XX-??">"
"Map" #### "<" ##-##">"
"Map "&####&" <"&##&"-"&##&">"
"Map " & #### & " <" & ## & "-" & ## & ">"
"Map "####" <"##"-"##">"
"Map" #### <##-##>
">!Map "0000 "\<"00-00"\>"
">!Map @@@@ \<@@-@@\>"
None of these work.
One other thing, the cell gets it's value from either this Offset
formula:
=IF(OFFSET(clStart,pfDisc,23)=0,"",OFFSET(clStart,pfDisc,23))
clStart is the reference row (A1 on CustList).
pfDisc is the row in the CustList sheet to be looked at.
23 is the column on that row where to data to be displayed is sitting.
Or direct entry in the edit mode which happens when this cell is
copied and pasted over itself with Edit>Paste special>Values, edited
copied back over to the CustList sheet as a new record and then the
formula is pasted back into the cell, There is some protection turned
off, on, off and back on also in the mix, but that should not be a
factor (I hope).
Anyone have any ideas to how to see Map 123A <BC-45> in a cell with
the cell value of 123abc45?
Any help, suggestions or direction would be appreciated.
-Minitman