Number Format

[ziad alsayed]

dear all

i am formatting a number by using the thousand seperator with No decimal, i want the $ currency to appear to the left, by using the currency format the $ is to close to the number . i want it like 2 space to the left of the number.

please advise.

 

[jeffreybrown]

Try a custom format of:

$ 0.00

 

[ziad alsayed]

dear Jeff


thanks for your reply , by using your suggestion i will loose the thousand seperator and i will have two decimals

e.g :let say the number is
<TABLE style="WIDTH: 98pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=131><COLGROUP><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4790" width=131><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 98pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=131>61258386.68</TD></TR></TBODY></TABLE>
i want the number to appear $ 61 258 387

please advise

 

[jeffreybrown]

Try...

$ ## ### ##0

 

[ziad alsayed]

thanks Jeff, perfect, i just removed the last two #

 

[jeffreybrown]

You're welcome...glad it worked out for you