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

Conversion

Status
Not open for further replies.
natncm70

natncm70

MIS
Jan 16, 2002
66
0
0
IN
Hello,

I need to the values(numbers) into Crores like
21,814,007,627.77 to 2181.40 . What should i do for that?
Please help me.

Regards
 
Sort by date Sort by votes
Hi, you can use the formula field (Insert>field objects>formula fields). create a new formula field. then in the editor of that formula field define one expression like : YourField/10000000.
Then format the field properly to get the values with your desired look.
hope this may work out ur problem.
Thanks,
Sabyasachi
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

keenoafc
  • Locked
  • Question
Date Conversion to Hours
Replies
1
Views
18
SkipVought
S
nyangi
  • Locked
  • Question
DateTime Conversion Crystal Reports 11
Replies
15
Views
44
nyangi
nyangi
saran26
  • Locked
  • Question
not getting the expected value after type conversion 1
Replies
3
Views
12
lbass
lbass
anushka04
  • Locked
  • Question
Date conversion
Replies
1
Views
5
Madawc
Madawc
Smithsc
  • Locked
  • Question
Text to Number Conversion
Replies
10
Views
28
Smithsc
Smithsc

Part and Inventory Search

Sponsor

Back
Top