Number formating

[Guest]

The results from one field in my query is in this format: 2316.52
I need that to look like this: 0000231652 Which is 10 characters long, zero
filled, and without the decimal.
Can anyone help?

 

[fredg]

The results from one field in my query is in this format: 2316.52
I need that to look like this: 0000231652 Which is 10 characters long, zero
filled, and without the decimal.
Can anyone help?

In your query:
NewColumn:Format([FieldName]*100,"0000000000")

 

[Guest]

yay i'm excited i can actually help!

select the cell you would like to format
right click, then select the option "format cells..."
make sure the number tab is selected, and scroll down to the category "custom"
in the entry space labeled "Type:", type 10 zeros or however many you want
finish by selecting ok

 

[Guest]

my apologies i thought you were using excel, so sorry again