Auto Decimals

D

donnajay

New Member
Joined
Jul 30, 2009
Messages
36
Good Morning:

I am importing numbers from another application that uses no decimals into an excel sheet. How do I get the cell to recognize, for example, 24205 is 242.05 and not 24205.00?

Any help would greatly be appreciated....:confused:

Donna J
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Hello and welcome to MrExcel.

Try Tools > Options > Edit tab > tick Fixed decimal and set places to 2.
 
Upvote 0
Thank You!

I did read that somewhere, but I didnt set it up before I imported the numbers. It is working great now! :)

Donna
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Stop Excel rounding decimal numbers up to next integer
Replies
5
Views
606
rlv01
R
R
  • Question Question
converting decimal time to days, minutes, hours
Replies
2
Views
480
rjwalker1973
R
K
  • Question Question
Cell format mix
Replies
3
Views
151
Karlheinz
K
Livin404
  • Solved
Random numbers add pointless decimals at end of whole number
Replies
4
Views
339
Livin404
Livin404
B
  • Question Question
When removing links with copy and paste special some values appear in scientific notation or expanded decimal places.
Replies
7
Views
268
BYahr
B

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top