formula to change something to a unit of 7 or 6 instead of decimal?

[tonywatsonhelp]

Hi everyone,

Not sure if this is possible but for reasons i can not go into I need a way to change a number the was calculated in decimal into unit7 and unit 6 (so binary is unit 2 if you know what I mean )

any ideas?

Tony

 

[AlanY]

have you tried the BASE() function?

 

[tonywatsonhelp]

I'll do that right now thank you Alan