Want to custom formatting a number similar to @,@ for text.

[QuasiChameleon]

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

 

[QuasiChameleon]

Please forgive my mistyping on the previous subject.

I think I just figured it out! I just need to put a ' in front of the
numbers, and they will be treated like text. So '15 looks like
"15,15", but can still be treated as a number in a lookup table.

Sorry to bother anyone, but this occurred to me only after I posted the
previous message.

Thanks anyway!

Kevin Crosby