View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
QuasiChameleon QuasiChameleon is offline
external usenet poster
 
Posts: 2
Default Want to custom formatting a number similar to @,@ for text.

Hi all,

I would like to format a number similar to what can be done for strings
with the @ placeholder.

However, the digit placeholder doesn't operate in the same way.

For example, for a character X, the custom format @,@ gives me X,X.

However, for a number 15, the custom format #\,# gives me 1,5 when I
would rather have 15,15.

I need the cell to contain a single number as part of a lookup table,
while appearing to be a pair.

Ideally I would have something like #\,#;;;@,@, except it actually
works.

Any suggestions?

Thanks in advance.

Kevin Crosby