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!

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

Yet one more format question

Status
Not open for further replies.

dneid

Technical User
Sep 1, 2007
3
US
OK, I really did not want to start a new thread, but......

I got the format problem solved... I explain it in a response to the original post. Now I need to ask how to format a numeric field where the variables are calculated in scientific notation (1.22757131e-03). Using @#.###### results in 0.001227. Using @<<<<<<<<<<<<<< results in 1.22757131e-03. While this works, I can not count on there always being 14 places in the string as some calculations result in longer strings (ie, 2.849274719294e-04) results in 2.849274719294 being printed. If anyone has any ideas they would be appreciated.

Thanks,
Dale
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top