# 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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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.