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 Rhinorhino 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
Joined
May 11, 2001
Messages
28
Location
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 Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
501
anandm19
anandm19
Sherry B
  • Locked
  • Question Question
Crystal division by zero using if in
Replies
12
Views
907
SkipVought
S
dellguy
  • Locked
  • Question Question
Dynamic parameter populated from command file query issue
Replies
2
Views
364
kray4660
kray4660
Bloke152
  • Locked
  • Question Question
More excel export issues!
Replies
2
Views
428
kray4660
kray4660
Cpreston
  • Locked
  • Question Question
Supress Report Footer Issue
Replies
14
Views
646
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top