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

Decimals

Status
Not open for further replies.
weltergon

weltergon

MIS
Oct 1, 2002
21
US
I am using Office XP and when I enter in a decimal it keeps getting rounded to up, so if enter 5.5, when I click off the field it shows up as 6. I've tried everything and I am not sure why its doing this,can anyone help?
Thanks in advance
 
Sort by date Sort by votes
set the field to any of the floating point data types



MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Upvote 0 Downvote
What does that mean, I have set it to decimal, long integer, integer etc. I have set the format to general, fixed etc. nothing seems to work.
 
Upvote 0 Downvote
Get a book. Learn about data types. Even (GASP) actually try the HELP system.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bjb21
  • Locked
  • Question
Decimals in Access 1
Replies
12
Views
63
dhookom
dhookom
CharlieT302
  • Locked
  • Question
Field Size vs. Decimals - How many decimals are stored. 1
Replies
5
Views
55
Golom
Golom
DLynnTX
  • Locked
  • Question
decimals are dropping during calculation 1
Replies
7
Views
51
DLynnTX
DLynnTX
Crevalle
  • Locked
  • Question
I'm stuck with decimals
Replies
5
Views
60
Ed2020
Ed2020
markphsd
  • Locked
  • Question
Please Help: Pivot Table is Rounding off decimals to 0
Replies
12
Views
306
markphsd
markphsd

Part and Inventory Search

Sponsor

Back
Top