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 derfloh 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
Joined
Oct 1, 2002
Messages
21
Location
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 Question
Decimals in Access
Replies
12
Views
248
dhookom
dhookom
CharlieT302
  • Locked
  • Question Question
Field Size vs. Decimals - How many decimals are stored.
Replies
5
Views
229
Golom
Golom
DLynnTX
  • Locked
  • Question Question
decimals are dropping during calculation
Replies
7
Views
203
DLynnTX
DLynnTX
Crevalle
  • Locked
  • Question Question
I'm stuck with decimals
Replies
5
Views
186
Ed2020
Ed2020
markphsd
  • Locked
  • Question Question
Please Help: Pivot Table is Rounding off decimals to 0
Replies
12
Views
610
markphsd
markphsd

Part and Inventory Search

Sponsor

Back
Top