# custom number format

i am trying to do a custom number format in exce eg.if the user enters 4 it should be 4+00
100 should be 100+00 ,35550 should be 355+50 etc.
###### Who is Participating?

IT Services ConsultantCommented:
OK, so, in summary...

35550 should be shown as 355+50.
1234 should be 12+34.
100 should be 1+00.
4 should be 0+04.

If that is correct, then please use this custom format:
0"+"00

<zero><quote><plus><quote><zero><zero>, for clarity.

Q-28244871.xls
0

IT Services ConsultantCommented:
Hi,

4 should be 4+00
100 should be 100+00
35550 should be 355+50

Should 1234 be 12+34?

BFN,

fp.
0

Author Commented:
1234 should be 1234+00
0

IT Services ConsultantCommented:
Thanks.

So, is the "rule" that only 5-digit (& above?) numbers do not have the "+00" suffix?
0

Author Commented:
bfn correction it should be 12+34, let's put it this way the + should be before the last 2 digits
0

IT Services ConsultantCommented:
If that is the case, then 100 should be 1+00.

Does that mean 4 should be 0+04?
0

Commented:
Hi,

I suppose what you are trying to do is separate Dollar values from Cents, but Excel cannot guess if 100 means 1 \$ plus 00 cents or 100%, as well if you enter 150 it cannot guess isf it is 1.50\$ or  150\$

\$ or the currency you are using

This only possible thing is to use in Excel Options/Advanced/Editing options/Automatiaclly insert a decimal point with 2 places: in that case is you enter 100 the result wil be 1 and 4 will be 0.04

Regards
0

Author Commented:
yes fanpages
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.