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

Number Format

Status
Not open for further replies.
Netherby

Netherby

Programmer
Nov 9, 2001
32
GB
Hi,

I am dealing with numbers with 9 digits after the decimal point such as 0.156943882 I would like to be able to format the number with gaps every three digits so it looks like 0.156 943 882
Can anyone help please? Thanks
 
Sort by date Sort by votes
Assuming you are displaying in a text field, set the text field's format to

0.000 000 000
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
307
TomSalvato
TomSalvato
caykamanj1966
  • Locked
  • Question
Available Numbers
Replies
1
Views
105
dhookom
dhookom
leifoet
  • Locked
  • Question
How to store decimal numbers in an Access database?
2
Replies
27
Views
550
Andrzejek
Andrzejek
rccline
  • Locked
  • Question
Highlighting Duplicates with Conditional Formatting 2
2
Replies
26
Views
512
strongm
strongm
DeRochier
  • Locked
  • Question
Conditional formatting on Yes/No fields
Replies
2
Views
164
Axworthy
Axworthy

Part and Inventory Search

Sponsor

Back
Top