Format Numbers on Export

  • Thread starter Thread starter Bill Sturdevant
  • Start date Start date
B

Bill Sturdevant

Sorry to repost, but I wanted to clarify the problem, and
I made a mistake in my example in my last posting.

In my table, I have the following values:
3.0
4.00
5.0B2

When I export them to Excel they become:
3
4
5.0B2

I WANT them to stay the same as in the table:
3.0
4.00
5.0B2

I use a query, and for the field in question, I tried:
Expr1:Format([Field],"0.0")
This gave me:
3.0
4.0
5.0B2
which is not what I wanted

I also tried:
Expr1:Format([Field],"0.00")
This gave me:
3.00
4.00
5.0B2
which is not what I wanted

I also tried:
Expr1:Format([Field],"General Number")
This gave me:
3
4
5.0B2
which is not what I wanted

The data MUST come out, with all formatting preserved, as:
3.0
4.00
5.0B2
 
Back
Top