var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: add - to cell data
i have a 10 digit value in my cell which i need to change to match the following:
with the dashes always being in after the:
1st, 4th, 6th and 9th numbers
If it is just for display purposes, format the cell with this custom type:
If you really need to have the hyphens within the value then you could use a formula such as:
Hope that helps...
ok it's nearly there, with the above formula i get
i am loosing a few digits
The formula I posted works absolutely fine for me. Example attached.
ok it seems to be a formatting issue, thanks for your help