How can i make Formula if i want the Amount i write on Excel cell automatically put it in between of Two Number Sign (#)
Example :
#1,526,262.55#
Edited 9-Jun-06 by geekgirlau. Reason: make thread title more specific
How can i make Formula if i want the Amount i write on Excel cell automatically put it in between of Two Number Sign (#)
Example :
#1,526,262.55#
Edited 9-Jun-06 by geekgirlau. Reason: make thread title more specific
Use a custom format of \##,##0.00\#;\#-#,##0.00\#