Quote:
Originally Posted by macropod
You will get an almost identical visual result with:
#,##0.00_-;#,##0.00_-;"-"??_-;_-@_-
or, if you can do without the trailing space:
#,##0.00;#,##0.00;"-"??;_-@
Either of these will eliminate the space padding.
|
Hi guys, thanks for all your help. Reformatting the source cells in excel worked the best.