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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

format number

Status
Not open for further replies.
neskin

neskin

Programmer
Mar 13, 2002
104
AU
Hi,
I am trying to display as 00:00 ,1:00 and ....in crystal xi currently I have field with number 0.00 ,1.00 and ...
I have tryed the formula
totext(left({field},2))+ ":00" does not work for me

thanks in advance
nat
 
Sort by date Sort by votes
If you want to change the decimal point to a colon, then go to format field->customize->decimal separator and replace the period with a colon.

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

Similar threads

LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
752
LauraW
LauraW
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
541
SarahSCPDAdmin
SarahSCPDAdmin
ejastia
  • Locked
  • Question
date format spacing 1
Replies
4
Views
465
ejastia
ejastia
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
512
BobSuruncle
BobSuruncle
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
480
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top