Placing a mask within a cell

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Howdy All,

Here is what I am trying to do.

I have a column with numbers in it. 1,2,3,etc.

I want to prefix these numbers with Page.. and have the results look this
this:

"Page..1"
"Page..2"

With the quotation marks included.

Can anyone help me out?

Thanks,
Brian
 
Thanks for the help JE.

One more question, is there a way for it to drop a "." when the page number
goes into double-digits?

Examples

"Page...1"
"Page..10"

Thanks again,
Brian
 
One way:

Format/Cell/Number/Custom

[<10]\""Page..."0\";[<100]\""Page.."00\";\""Page."000\"


Note that this will not align unless using a non-proportional font (like
Courier or Monaco).
 
Great!

Thanks JE!


JE McGimpsey said:
One way:

Format/Cell/Number/Custom

[<10]\""Page..."0\";[<100]\""Page.."00\";\""Page."000\"


Note that this will not align unless using a non-proportional font (like
Courier or Monaco).


Brian said:
Thanks for the help JE.

One more question, is there a way for it to drop a "." when the page
number
goes into double-digits?

Examples

"Page...1"
"Page..10"

Thanks again,
Brian
Click to expand...
Click to expand...
 
Back
Top