Working with numeric formats
QuattroProletsyouformatnumbersinyourspreadsheet.Forexample,you
canformatanumbertodisplayaspecificnumberofdecimals.Youcanuse
the existingnumericformatsinQuattroProoryoucancreateyourown
numericformatstofurthercustomizetheappearanceofnumbers.For
informationaboutcreatingcustom formats,see“Workingwithcustom
formats”onpage195.
Therearetwogroupsof formats:numberformatsanddate/timeformats.For
moreinformationaboutDate/Timeformats,see“Workingwithdate,time,
andcurrencyformats”onpage193.
Bydefault,whenyouenteranumber,thecolumnwidthexpandstofitit
(unlessthenumberhasaGeneralformat).Ifcolumnsdonotexpandwhen
youenternumbers,enabletheFit-As-You-Gotool.Formoreinformation
aboutchangingcolumnwidthasyouenternumbers,see“UsingQuickFitand
Fit-As-You-Go”onpage209.
Changing the numeric format of cells
Numericformatsdonotaffectcellvalues;theyaffectonlythewayvaluesare
displayed.Forexample,aformatthatlimitsthenumberofdecimalplaces
thatappeardoesnotaffecttheprecisionof QuattroProcalculations,whichis
accurateto16significantdigits.
Whenyouenternumbers,QuattroProdisplaystheminthedefaultGeneral
format.Youcanchangehowthenumberdisplays(forexample,addcommas,
dollarsigns,specificnumberofdecimals,othercharacterstothenumber,
etc.),selectapredefinedstyle,orsetaspecificnumericformat.
Asignificantdigitreferstoanydigitthatisnotaleadingzero.Forexample,
the number1.23hasthreesignificantdigits.Thenumber.000829alsohas
threesignificantdigitsbecausetheleadingzerosdonotcount.Decimals,
commas,dollarsigns,andpercentsignsdonotcountasdigits.
QuattroProroundstheappearanceofnumberstothespecifieddecimalplace
inthecaseoffixed,scientific,currency,comma,andpercentformats.The
generalformatroundsofffractionalnumbersasnecessarytofitinthecell.To
roundthenumberactuallystoredinacell,use@ROUND.Forinformation
aboutspreadsheetfunctions,see “Workingwithspreadsheetfunctions”on
page139.
To change the numeric format of cells
1 Selectthecellstoformat.
2 ClickFormat,Selection.
3 Clickthe NumericFormattab.
Editingandformattingaspreadsheet
191
Pdf text select tool - search text inside PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Learn how to search text in PDF document and obtain text content and location information
search text in multiple pdf; pdf searchable text
Pdf text select tool - VB.NET PDF Text Search Library: search text inside PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
Learn How to Search Text in PDF Document and Obtain Text Content and Location Information in VB.NET application
how to select all text in pdf file; pdf search and replace text
4 Enablethebuttonthatcorrespondstotheformatyouwantkeepingthe
followinginmind:
Ÿ IfyouenableGeneral,numbersdisplayexactlyasyouenterthem.
Ÿ Iftheformatallowsavariablenumberofdecimalplaces,typeanumber
from0to15(thedefaultis2)intheEnterNumberofDecimalPlaces
box.
Ÿ Iftheformatallows,choosehowyouwantnegativenumberstodisplay.
Ÿ IfyouenableNumber,youcanchoosetoincludethe1000separator
(comma).
Ÿ IfyouenableCurrency,choosethecountrycurrencysymboltouse.
YoucanalsousetheAccountingAlignmentoption.
Ÿ IfyouenableFraction,choosethefractiontype.EnabletheReduced
Fractioncheckbox toreducefractionstotheirlowestcommon
denominator.
Ÿ IfyouenableCustom,selectapreviouslydefinedcustomformator
clickAddtocreateanewcustom format.
Ÿ QuattroProhasaddedtheEurototheavailablecurrencyformats.Youcan
viewtheEurocurrencysymbolifyouareusingMicrosoftWindows98or
ifyoursystemhasaEurocompliantfontinstalled.
Ÿ IfyouenabletheHiddenbutton,youhidecells.Topreventthemfrom
beingaccidentallyoverwritten,protectthesheetwithFormat,Sheet
Protection,EnableCellLocking.
Ÿ ForinformationaboutoneormoreofthecheckboxesintheNumeric
Formatdialogbox,clicktheWhat’sThisbuttonandpointtothe
appropriatecheckbox.
Hiding zeros on a spreadsheet
QuattroProletsyouhideallvaluesthatequalzeroonyourspreadsheet.For
example,avaluesuchas.004thatappearsas0ifdecimalprecisionis0,will
stillappear,evenif DisplayZerosissettoNo,becauseitisnotactually0.
Hidingzerosdoesnotremovezerovaluesfromthesheet.Zerosremainin
memoryandreappearifyouchangetheDisplayZerossetting.
Itiseasytoaccidentallyoverwritecellscontainingformulasthatevaluateto
zero.MakesureUndoisenabled,orconsiderprotectingthespreadsheet.For
informationaboutenablingUndo,see“Undoingactionsandoperations”on
page165.Forinformationaboutprotectingyourspreadsheet,see“Protecting
data”onpage162.
192
QuattroPro9:Chapter7
C# HTML5 PDF Viewer SDK to view PDF document online in C#.NET
Tools Tab. Item. Name. Description. 1. Select tool. Select text and image on PDF document. 2. Hand tool. Pan around the document. Go To Tab. Item. Name. Description
cannot select text in pdf; search pdf files for text
VB.NET PDF- View PDF Online with VB.NET HTML5 PDF Viewer
Tools Tab. Item. Name. Description. 1. Select tool. Select text and image on PDF document. 2. Hand tool. Pan around the document. Go To Tab. Item. Name. Description
how to select text in a pdf; how to select all text in pdf
To hidezeros on asheet
1 ClickFormat,Sheet,Display.
2 EnabletheNobuttonintheDisplayZerossection.
Working with date, time, and currency formats
QuattroProletsyouformatdatesandtimesinyourspreadsheet.Youcanuse
the existingformatsinQuattroProorcreateyourowncustom formatsto
furthercustomizetheappearance ofdatesandtimes.Forinformationabout
creatingcustom formats,see“Workingwithcustomformats”onpage195.
TheInternationalcurrency,date,andtimeformatscorrespondtothe
InternationalsettingslocatedinTools,Settings.Ifyouchangethesesettings,
youmustconformtothenewsettingswhenyouentercurrency,dates,or
times.Bydefault,QuattroProdisplaystimesinlongformasHH:MM:SS(for
example,09:32:30),orinshortformasHH:MM (forexample,09:32)when
nosecondshavebeenspecified.Onceyouenteradateortime,youcan
reformatittoanysettingyouchoose.Formore informationabouttime
formats,see“Applyingformatstodatesandtimes”onpage105.For
informationaboutchangingtheInternationalcurrency,date,andtime
formats,see“Usinginternationalsettings”onpage57.
Editing dates inprevious versions of Quattro Pro
Anytwo-digityearsenteredinacellorformulaasalabelinearlierversions
ofQuattroPronowusethetwo-digityearentrywindow.Forexample,ifcell
A1containsthelabel‘1/1/20’(assumedtobe1/1/1920inversionsofQuattro
PropriortoQuattroProversion7upgradedforWindowsNT),theformula
@DATEVALUE(A1)nowreturnstheintegerdatevaluefor1/1/2020.
Youshouldchangeanylabelpreviouslyenteredusingatwo-digityeardate
formattoafour-digityeardateformattoexplicitlyindicatethecentury.(For
example,editthelabel‘1/1/20’as‘1/1/1920’.)
Onceyouhavechangedadatelabelfrom twotofourdigits,thecentury
designationremainsunlessyouoverrideitbyre-enteringallfouryeardigits
ofthedate.Formoreinformationaboutdateformats,see“Applyingformats
todatesandtimes”onpage105.
Exchanging dateinformation between applications
Whenyouimportdatacontainingdatesinstringsornumericformatfroman
applicationthatdoesnotsupportfour-digityeardateformats,thedata
importedmayalsousethetwo-digityearwindow.
AllQuattroPro8datefunctionsupdatedforeasiermulti-centuryuseremain
compatiblewithpreviousversionsofQuattroPro.Forexample,@DATE
Editingandformattingaspreadsheet
193
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
and use the PDF page(s) extraction tool. As String = Program.RootPath + "\\" 1.pdf" Dim doc As PDFDocument = New PDFDocument(inputFilePath) ' Select pages.
text select tool pdf; pdf find text
C# WPF PDF Viewer SDK to annotate PDF document in C#.NET
Default create. Click to select drawing annotation with default properties. Other Tab. 17. Text box. Click to add a text box to specific location on PDF page.
how to select text in pdf reader; search a pdf file for text
(26,3,12)willreturn16873(12-Mar-1926)inQuattroPro8andallprevious
versions.
Setting the datedefault to display four digits
Youcansetalldatestodisplayinafour-digityearformatbydefault.In
Windows(Settings,ControlPanel,RegionalSettings),setthepreferreddate
shortstyleformattoM/d/yyyy.ExitWindows(Settings),thensetthedefault
DateFormatinQuattroProtoWindowsDefault(Tools,Settings,
International,DateFormat).
Formatting dates
QuattroProstoreseachdateyouenterasafive-digitserialnumber.Quattro
Prousesthisnumberforcalculations.Ifyoutypeadate,itdisplaysinthe
formatinwhichyoutypeit.Ifyouenterthedateusing@DATE,
@DATEVALUE,or@NOW,youmustreformatthecellswiththedate
numericformat.Otherwise,QuattroProdisplaystheresultsasadateserial
number.Forexample,33857appearsinsteadof10-Sep-92.
To format dates
1 Selectthecellstoformat.
2 ClickFormat,Selection.
3 Clickthe NumericFormattab.
4 EnabletheDatebutton,thenchooseaspecificdateformatfromthelist
box.
Formatting times
Onceyouenteratimeinthespreadsheet,youcanchangetoanothertime
formatwiththeNumericFormatproperty.
To format times
1 Selectthecellstoformat.
2 ClickFormat,Selection.
3 Clickthe NumericFormattab.
4 EnabletheTimebutton,thenchooseaspecifictimeformatfromthelist
box.
194
QuattroPro9:Chapter7
VB.NET PDF - Annotate PDF with WPF PDF Viewer for VB.NET
Default create. Click to select drawing annotation with default properties. Other Tab. 17. Text box. Click to add a text box to specific location on PDF page.
can't select text in pdf file; pdf search and replace text
C# HTML5 Viewer: Load, View, Convert, Annotate and Edit OpenOffice
Office PowerPoint (.ppt, .pptx) on webpage, Convert CSV to PDF file online C#.NET RasterEdge HTML5 Viewer particular text tool can select text on all
how to select text in pdf; search pdf files for text programmatically
Working with custom formats
Customformatsletyouchange howvaluesareformatted,including
numbers,dates,andtimes.QuattroProprovidesseveralpredefinedcustom
formats.Youcaneditoneof theseformatsoryoucancreateanewformat.
Youcanpreviewacustomformatinthepreviewboxlocatedunderthe
CustomFormatslist.
Usingtheadvancedcustom formatoptionsyoucan
Ÿ customizetheformatofvalues(e.g.,numbers,dates,andtimes)
Ÿ setconditionsinaformatstatement
Ÿ adjusthowavalue displaysusingarithmeticoperatorsforexample,you
candivide10,000by1,000todisplayitas10K;thevalueinthecell
remains10,000butdisplaysas10Kinthespreadsheet
Ÿ addrichtextformattingtoformattedvalues(e.g.,fonttype,size,and
color)
Ÿ displaynumericvaluesashorizontalbarstocreateagraphical
representationofdata
Acustomformatcancontainmorethanoneformatstatement.QuattroPro
maintainsasummaryofeachformatstatementintheFormatSummary
sectionofthecustomformat.
NewcustomformatsareaddedtotheCustomFormatslistinallopen
notebooks,butonlythecustomformatsyouapplytocellsinopennotebooks
aresaved.Ifyoupasteaformattedcellintoanothernotebook,thecustom
formatalsocopies.
Forinformationabouttheavailablenumberformats,see“Addingnumeric
formatcodes”onpage195.Forinformationabouttheavailabledateortime
formats,see“Addingdateformatcodes”onpage197and“Addingtime
formatcodes”onpage198.
Adding numericformat codes
Youcancustomizetheformatusedfornumbersinyourspreadsheetusing
numericformatcodes.Youcanalsocustomizetheformatofdatesandtimes.
Forinformationaboutcustomizingdateformats,see“Addingdateformat
codes”onpage197.Forinformationaboutcustomizingtimeformats,see
“Addingtimeformatcodes”onpage198.
Forinformationaboutapplyingnumericformatcodes,see“Creating,editing,
andapplyingcustomformats”onpage199.
Thetablebelowoutlinesanddescribeseachnumericformatcodeavailablein
QuattroPro.
Editingandformattingaspreadsheet
195
VB.NET PowerPoint: VB Codes to Create Linear and 2D Barcodes on
then apply PPT slide getting method to select the target PowerPoint PDF 417 barcode library is a mature and offers users the human readable text setting option
convert pdf to searchable text; select text in pdf file
TIFF to PDF Converter | Convert TIFF to PDF, Convert PDF to TIFF
for TIFF-PDF Conversion; Able to preserve text and PDF Open TIFF to PDF Converter first; Load a TIFF Select "Convert to PDF"; Select "Start" to start conversion
select text in pdf; text searchable pdf file
Numericformatcode
Description
0
Alwaysdisplaysadigit.Ifthenumberdoesnothaveadigitinthis
position,azeroappears.Iftherearemoredigitsinthenumberthan
zerosintheformatcode,extradigitsintheintegerportionaredisplayed
andthefractionportionisrounded.
9
Displaysadigitifthenumberhasone.Iftherearemoredigitsinthe
numberthanninesintheformatcode,extradigitsintheintegerportion
aredisplayedandthefractionportionisrounded.
,(comma)
Insertsathousandsseparator(acommaunlessspecifiedotherwisewith
theapplication’sInternationalproperties).Ifnotpartofanumbercode,
thecommaisinsertedwhereveritispositionedintheformat.
.(period)
Insertsadecimalseparator(aperiodunlessspecifiedotherwisewiththe
application’sInternationalproperties).
E-ore-
Displaysthenumberinscientificnotation,precedingnegativeexponents
withaminussign.Iftheformatincludesatleastonezeroornine
followingthissymbol,thenumberdisplaysinscientificnotationwithE
ore.Iftheexponentcontainsmoredigitsthanninesorzerosfollowing
thissymbol,theextradigitsaredisplayed.
E+ore+
Displaysnumbersinscientificnotation,precedingpositiveexponents
withaplussign.Iftheformatincludesatleastonezeroorninefollowing
thissymbol,thenumberdisplaysinscientificnotationwithEore.Ifthe
exponentcontainsmoredigitsthanninesorzerosfollowingthissymbol,
theextradigitsaredisplayed.
?//M
Displaysafractionfollowedbythemaximumnumberofdigitsforthe
denominator.
?//
Displaysafractionfollowedbythedenominatortouse.Thefractionis
notreduced.
?//R
Displaysafractionfollowedbythebasedenominatortouse.Thefraction
isreducedifpossible.
*(asterisk)
Fillsthecolumnbyrepeatingthecharactertotherightoftheasterisk.
_(underscore)
Skipsthespacethatwouldhavebeenrequiredtodisplaythecharacter
thatfollowstheunderscore.Thisletsyoualignnumbersforformatswith
optionaltrailingcharacterssuchasnegativenumberswithparentheses.
|(bar)
Displaysthefirstcharacterfollowingthe|codeinthespacethatwould
havebeenrequiredtodisplaythesecondcharacterfollowingthe|code.
Thisallowsthealignmentofformatswithdifferenttrailingcharacters,
suchastheKMegGigpredefinedformat.
196
QuattroPro9:Chapter7
XDoc.HTML5 Viewer for .NET, All Mature Features Introductions
NET developers to search text-based documents, like PDF, Microsoft Office The well built-in text search tool is compatible with most Text Select, Copy & Paste.
convert a scanned pdf to searchable text; find text in pdf image
VB.NET PDF - Convert PDF Online with VB.NET HTML5 PDF Viewer
tiff, VB.NET read PDF, VB.NET convert PDF to text, VB.NET Export PDF to Tiff file. Users are allowed to set scaling value and select compress mode: UnCompressed
find and replace text in pdf file; select text pdf file
LeftBar
Displaysthenumberasaredhorizontalbarstartingattheleftofthecell
usingtherange0to100.Youcanchangethelimitsoftherangeandthe
barcolor.
CenterBar
Displaysthenumberasaredhorizontalbarstartinginthecenterofthe
cell.Usestherange0to100fromthecentertotheleft,and0to100
fromthecentertotherightofthecell.Youcanchangethelimitsofthe
rangeandthebarcolor.
RightBar
Displaysthenumberasaredhorizontalbarstartingattherightofthe
cellusingtherange0to100.Youcanchangethelimitsoftherangeand
thebarcolor.
General
UsestheGeneralnumericformat.
Adding date formatcodes
Youcancustomizetheformatfordatesinyourspreadsheetusingdateformat
codes.Youcanalsocustomizetheformatofnumbersandtimes.
Forinformationaboutcustomizingnumberformats,see“Addingnumeric
formatcodes”onpage195.Forinformationaboutcustomizingtimes,see
“Addingtimeformatcodes”onpage198.
Forinformationaboutapplyingdateformatcodes,see“Creating,editing,and
applyingcustomformats”onpage199.
Thetablebelowoutlinesanddescribesthedateformatcodesavailablein
QuattroPro.
Dateformatcodes
Description
d
Displaysthedayofthemonthasaone-ortwo-digitnumber(1-31).
dd
Displaysthedayofthemonthasatwodigitnumber(01-31).
wday,Wday,WDAY
Displaysthedayoftheweekasathree-characterabbreviationin
lowercase,withthefirstlettercapitalized,orinuppercase.
1wday,1Wday,1WDAY
Displaystheweekdayasanabbreviationusingthenumberofcharacters
youspecifyinlowercase,withthefirstlettercapitalized,orinuppercase.
weekday,Weekday,WEEKDAY
Displaysthedayoftheweekinlowercase,withthefirstletter
capitalized,orinuppercase.
mo
Displaysthemonthasaone-ortwo-digitnumber(1-12).
mmo
Displaysthemonthasatwo-digitnumber(01-12).
mon,Mon,MON
Displaysthemonthasathree-characterabbreviationinlowercase,with
thefirstlettercapitalized,orinuppercase.
Editingandformattingaspreadsheet
197
1mon,1Mon,1MON
Displaysthemonthasanabbreviationusingthenumberofcharacters
youspecifyinlowercase,withthefirstlettercapitalized,orinuppercase
(e.g.,SEPT).
month,Month,MONTH
Displaysthenameofthemonthinlowercase,withthefirstletter
capitalized,orinuppercase.
yy
Displaysthelasttwodigitsoftheyear(00-99).
yyyy
Displaysallfourdigitsoftheyear(0001-9999).
*(asterisk)
Fillsthecolumnbyrepeatingthecharactertotherightoftheasterisk.
_(underscore)
Skipsthespacethatwouldhavebeenrequiredtodisplaythecharacter
thatfollowstheunderscore.Thisletsyoualignnumbersforformatswith
optionaltrailingcharacters,suchasnegativenumberswithparentheses.
|(bar)
Displaysthefirstcharacterfollowingthe|codeinthespacethatwould
havebeenrequiredtodisplaythesecondcharacterfollowingthe|code.
Thisallowsthealignmentofformatswithdifferenttrailingcharacters,
suchastheKMegGigpredefinedformat.
Adding timeformat codes
Youcancustomizethetimeformatsinyourspreadsheetusingtimeformat
codes.Youcanalsocustomizetheformatfornumbersanddatesinyour
spreadsheet.
Forinformationaboutcustomizingnumberformats,see“Addingnumeric
formatcodes”onpage195.Forinformationaboutcustomizingdateformats,
see“Addingdateformatcodes”onpage197.
Forinformationaboutapplyingtimeformatcodes,see“Creating,editing,and
applyingcustomformats”onpage199.
ThetablebelowoutlinesanddescribesthetimecodesavailableinQuattro
Pro.
Timeformatcodes
Description
s
Displayssecondsasaone-ortwo-digitnumber(1-59).
ss
Displayssecondsasatwo-digitnumber(01-59).
[ss]
Displaysacountinsecondsthatcanexceed60(formats00:01:01as61
seconds).Thisformatshouldnotbeusedwithyear,month,day,hour,or
minutecodes.
mi
Displaysminutesasaone-ortwo-digitnumber(1-59).
mmi
Displaysminutesasatwo-digitnumber(01-59).
198
QuattroPro9:Chapter7
[mmi]
Displaysacountinminutesthatcanexceed60(formats01:01:01as61
minutes).Thisformatshouldnotbeusedwithyear,month,day,orhour
codes.
h
Displaysthehourasaone-ortwo-digitnumber(1-24).Iftheformat
includesam/pmorAM/PM,thenumberisbetween1-12.Ifam/pmor
AM/PMisnotincluded,the24-hourformat(0-24)isused.
hh
Displaysthehourasatwo-digitnumber(01-24).Iftheformatincludes
am/pmorAM/PM,thenumberisbetween01-12.Ifam/pmorAM/PMis
notincluded,the24-hourformat(00-24)isused.
[hh]
Displaysacountofhoursthatcanexceed24(e.g.,formatsonedayand
onehouras25hours).Thisformatshouldnotbeusedwithyear,month,
ordaycodes.
.s
Displaysthedecimalportionofseconds(thenumberofdigitstodisplay
followsthisformat).
.mi
Displaysthedecimalportionofminutes(thenumberofdigitstodisplay
followsthisformat).Thisformatshouldnotbeusedwithsecondscodes.
.h
Displaysthedecimalportionofhours(thenumberofdigitstodisplay
followsthisformat).Thisformatshouldnotbeusedwithminutesor
secondscodes.
aorA
Displaysashortenedversionofam/pmandsetsthetimetoa12-instead
ofa24-hourformatineitherlowercaseoruppercase.
amorAM
Displaysam/pmineitherlowercaseoruppercaseandsetsthetimeto12
hourinsteadof24hour.
Creating, editing, and applying custom formats
Withcustomformatsyoucanchangethewaydates,times,ornumericvalues
appearinyourspreadsheetusingaformatstatement.Aformatstatement
mustcontainformatcodes.Thesecodes,whenappliedtovaluesinthe
spreadsheet,changethewayvaluesareformatted.Forexample,youcanadd
aformatstatementwithspecificdatecodestodisplaythedate01/23/99as
January23,1999.Or,youcanusetime codestoformatthetime00:01:01to
appearas61seconds.
Youcanaddtextwithformatcodes.Thetextappearsinacellwhenyouapply
the custom format.Forexample,if youusethenumericformatcode9and
thentypecmintheFormatbox,the numberfiveappearsinthespreadsheet
as5cm.
Youcaneditanexistingcustomformatoryoucancreateanewcustom
format.Whenyoucreateanewcustomformat,youmodifyanexistingformat
andsave itwithanewname.Bydefault,whenyoumodifyanexistingformat
QuattroProchangestheformatname.
Editingandformattingaspreadsheet
199
Forinformationaboutspecificformatcodefunctions,see“Addingnumeric
formatcodes”onpage195.“Addingdateformatcodes”onpage197,and
“Addingtimeformatcodes”onpage198.
To create a custom format
1 Selectthecellforwhichyouwanttocreateacustomformat.
2 ClickFormat,Selection,thenclicktheNumericFormattab.
3 EnabletheCustombutton.
4 FromtheCustomFormatslist,choose theformatthatmostclosely
resemblestheonetowhichyouwantto create,thenclicktheAddbutton.
5 IntheFormatSummarysection,typeaformatnameintheFormatName
textbox.
6 IntheFormatsection,considerthefollowingoptions:
Ÿ Toaddanumericformat,clicktheAddNumericCodebutton,then
chooseaformatcodefromthelistbox.
Ÿ Toaddadateortimeformat,clicktheAddDate/TimeCodebutton
thenchooseaformatcodefrom thelistbox.
Ÿ Toaddrichtextformattingtoformatcodes(e.g.,textcolorandfont
typeandsize),selecttheformatcodeintheFormatbox,thenapply
formattingusingthe textformattingbuttonsintheFormatsection.
Ÿ Toaddtexttobedisplayedwiththeformat,clickinside theFormat
box,thentypethetext.
Ÿ AsummaryoftheformatstatementappearsintheFormatSummary
sectionundertheFormatlabel.
Ÿ YoucanaddtotheexistingformatcodesintheFormatsectionoryoucan
deletethesecodesaltogether.
To edit a custom format
1 Selectacellformattedwiththecustom formattoedit.
2 ClickFormat,Selection,thenclicktheNumericFormattab.
3 Clickthe Editbutton.
4 Maketheappropriatechangestothecustomformat.
200
QuattroPro9:Chapter7
Documents you may be interested
Documents you may be interested