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

Number convertation

Status
Not open for further replies.
SmartDen

SmartDen

Programmer
Feb 18, 2003
8
DE
Hi@All!

How can i automaticly convert an entered number like this 7.89 to something like this 0.0789.
I tryed to enter a formula to devide the numberwith 100 into a cell, but it doesn't work.
Can i reach for the same effect with a format string?

SmartDen
 
Status
Not open for further replies.

Similar threads

hikermann
  • Locked
  • Question
Editing numbering styles
Replies
0
Views
105
hikermann
hikermann
hikermann
  • Locked
  • Question
Numbering - Macros
Replies
0
Views
75
hikermann
hikermann
paw
  • Locked
  • Question
numbering endnote pages in wordperfect
Replies
2
Views
88
ajetrumpet
ajetrumpet
bobinot
  • Locked
  • Question
counting certain numbers
Replies
1
Views
38
diogenes10
diogenes10
seananton
  • Locked
  • Question
Finding number of values less than a given value
Replies
0
Views
26
seananton
seananton

Part and Inventory Search

Sponsor

Back
Top