PDA

View Full Version : Formatting a number



Exhumes
06-07-2006, 01:00 AM
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

Bob Phillips
06-07-2006, 02:01 AM
Use a custom format of \##,##0.00\#;\#-#,##0.00\#