number format

[GetReel]

how do you format a number so that the default is set to 05 .
Ive set the format to 00 and then set the dafualt to 05 but he value is being stored as 5 which is what I dont want.

 

[R. Hicks]

If the numeric value is not being "Indexed", used to sort the records, or used in a calculation within the app ... change the datatype in the table to "Text".

Else .... you will have to format the numeric value to display in your wanted format wherever it is needed in the application.

HTH
RDH

 

[GetReel]

Thanks!