Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Leading Zero Issue 1

Status
Not open for further replies.
see123

see123

Programmer
May 11, 2001
28
0
0
US
I have field in DB as number X = .6250. I need to display this filed as 0000000.6250

Used a formula to convert this filed to fixed length

ToText(X,"0000000.0000",2,"",".")

But this number is rounded to 000000.6300

any ideas please


 
Sort by date Sort by votes
The 2 is stating 2 decimal places, change it to 4, as in:

ToText(X,"0000000.0000",4,"",".")

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
68
anandm19
anandm19
Sherry B
  • Locked
  • Question
Crystal division by zero using if in
Replies
12
Views
114
SkipVought
S
dellguy
  • Locked
  • Question
Dynamic parameter populated from command file query issue
Replies
2
Views
71
kray4660
kray4660
Bloke152
  • Locked
  • Question
More excel export issues!
Replies
2
Views
74
kray4660
kray4660
Cpreston
  • Locked
  • Question
Supress Report Footer Issue 1
Replies
14
Views
42
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top