Values are changing to decimals

[Jackie]

I am entering Values in cells, and all my numbers are
changing to decimals. This isnt a formatting issue as my
formats are text, general or number. Exporting is fine,
and the values come through as numbers just fine.
I've gone through Tools - Options, but haven't found a
solution yet. Any suggestions?

 

[Guest]

Jackie, I think the issue is the way formatting is being handled in Excel. Go to the Format option then, select Cells, then numbers and change your decimals to 0. That should do it. Otherwise, let me know what the fomatting is now and we can check a couple of other things. Best of luck

----- Jackie wrote: ----

I am entering Values in cells, and all my numbers are
changing to decimals. This isnt a formatting issue as my
formats are text, general or number. Exporting is fine,
and the values come through as numbers just fine
I've gone through Tools - Options, but haven't found a
solution yet. Any suggestions

 

[Peo Sjoblom]

Uncheck fixed decimal place under tools>options>edit

 

[J.E. McGimpsey]

Did you uncheck the Fixed decimal places checkbox in
Tools/Options/Edit?

 

[Jim]

Tools>Options>Edit tab>*Uncheck Fixed Decimals (or change it to what you
need)>OK