Free Microsoft Excel 2013 Quick Reference

decimal points

Hi im new to this!
I have opened an existing file and all of the decimal points are displayed as plus signs (+) can someone tell me how to change them back please.

Post your answer or comment

comments powered by Disqus

In Greek version of Office "," is decimal point and not ".". I would like to change this setting through code! Any ideas?
I've searched in vba excel help but the only thing I found was


If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
and it is referred as read-only!

Thank you in advance for your time and suggestions!


i have numbers punched in my workbook upto three significant figures after the decimal point e.g; 650,250.897 which are proving a trouble to me.How can i select figures like this (i have such figures in many columns) and delete the digits after the deciaml (.897) and rounding the remaining digits to 650,251.i want deletion of that numbers and i cant use the ROUND function.
Thanks in advance.

GoodBYe to all

Whiling finding a solution to my problem, I cam across the following thread. which helped me somewhat but I need a solution to the trailing decimal point also. I need numbering format that allows one decimal place but do not show either zero or the decimal point.

For example , if my number is 9.0, it should be shown as 9 and :" 9." with the decimal hanging . If my number is 9.1, then it should be should as 9.1.

The format of 0.# is not helping me here.

Okay, I've got a wierd simple problem in Excel 2003. I have a laptop and a desktop machine, and I'm an accountant who uses the fixed decimal feature as a default, with it set to 2 decimal places.

On the desktop machine, if I input "23." into a cell and then hit enter, the value left in the cell is "23.00" However, on the laptop, when I do the same thing, I get "0.23" In essence, it ignores the fact that I entered a decimal point.

If I enter "23.0" in a sheet on the laptop, it puts "23.00" in the cell.

I thought maybe it was some sort of hardware thing, like the KB was messed up, but then I used remote desktop to try to see what would happen if I enter numbers into the other computer using the laptop, and into the laptop using the desktop. The laptop when connected to the desktop performed normally, just like the desktop machine. The desktop, when connected remotely to the laptop behved like the laptop machine. In other words, I believe this test takes Hardware out of the picture.

Which leaves some strange obsure setting in excel someplace tht is causing this behavior, and I can't seem to find it.

Does anyone here know why these two installs treat the data entry so differently? It's driving me nuts.

Many thanks,


I have converted a DOS file into excel and I needed to add a decimal point to some of the data. Through this site I found out how to add the decimal point that I needed by putting 10 in an empty cell and then copy it and then selecting the cells I need to change and doing a Paste Special and divide but my problem is if the number ends in zero the zero disapears for example the number is 1250 and I need it to be displayed as 125.0 not 125. All the data is in text. How can I keep the zero's from disapearing. Thanks in advance

Hi guys im new here,

i would like to ask, how i will insert a decimal point between 8 digit number on multiple cells.

from 90309090 = 9030.9090

btw, im using MS Office 2010

thanks guys

more power to this site

Would like to do the following for our school,
In cell A1 there is a number, for instance: 12.12345

Based on that number, the 3rd number after the decimal is important.

If the 3rd number after the decimal is “x” then the contents returned in b2 is a text value ( like high school ).

ColA ColB
12.12145 middle school
12.12245 elementary school
12.12345 high school
12.12445 charter school
12.12545 special education
12.12645 advanced placement
12.12745 athletic departments
12.12845 special placements
12.12945 ais schools

So based on the value 0-9 that is in the 3rd number after the decimal, a text value in B2 is one of nine choices.

Additional requirement
1) The amount of numbers before the decimal point is variable
2) the number of values after the decimal point is equal to or larger than 3.
3) able to change the pivotal value after the decimal from 3 to another value ( say 2nd or 4th )

Your help is greatly appreciated.

Is there some kind of function that will remove decimal points from a number ?

What I'm looking for is:

1231.5 = 12315
123.15 = 12315
12.315 = 12315
1.2315 = 12315

Can anyone help ?

Thanks in advance

Hi everyone,

I have a quick one that I think can't be fixed without an If function, but thought I'd check anyway.

I have a heap of values that are along the lines of:


Is there a specific cell format I can use to hide the decimal point for any cell where the value is an integer? Turning the above in to:


I can do it with an If statement, I can get rid of the trailing zero with a cell format (##.#%) but I can't remove the decimal point itself.

Any ideas anyone?

Kind regards,

A question probably asked before and quite simple! I have columns of geological data in number form which may have about 4 or 5 decimal points. I want to reduce them to 2 decimal points without rounding the numbers up.

Is there a simple way to do this?

Ignorant in Despair

Hi all--

I've got a column with about 1100 entries that look like this:


How can I make all of them look like this (i.e. decimal point inserted before last two digits):


in a few easy clicks?

Thanks in advance.

undefined I need to change my workbook so that excel won't round decimals - i just want to have 2 places after the decimal point - how do i do that?

I import a .csv file regularly. The csv file holds some numerical columns which have no decimal point. So the columns are, for example 2340 instead of 23.40. At the moment I create a new column then create the forumla, again for example, =A2/100 and then copy and paste special/values back to the original column.

is there a way of just formatting the original column to take care of the decimal point? There are a lot of numerical columns in the csv file so it's taking me a while to format it.

I asked this question the other day, but didn't get any responses...

I have a VBA input form where I enter numbers which are dumped into an excel spreadsheet. Whenever I enter a number with a decimal point, it is entered in the sheet as text. How can I make it enter as a number?

Thanks in advance!

I am trying to format a column to display a number with 15 positions and an implied decimal. The decimal point is assumed but not entered. There would be 10 positions before the assumed decimal and 5 after the assumed decimal.


417.93 would show as 000000041793000
3,576.18 would show as 000000357618000

Thanks for any help.

Hi everyone

Is there anyway to be able to bring decimal point forward without affecting the numbers using any formatting, which will still be there even after refreshing the query.

For example, 0.0531 to 53.1


hello, i am calculating the difference of two cells. example, a3=a1-a2. a3 gives me a result with a decimal point, example, 1.34564. i want to move the decimal on the result right one or two spaces. example, 13.4564. a1 and a2 are imported from another worksheet so i am having trouble with this. any idea's anyone? thanks.

Hello there, i am having trouble with decimal points when i am mailmerging into Microsoft Publisher. I have tried formatting the numbers in the spreadsheet but them when i mailmerge all of the decimal points come back again! In the past if it is a small list of numbers i generally just retype them in the next column of the spreadsheet with the 2 decimal places that i require. I am hoping there is a more suitable way of doing this as i now need to merge figures from a spreadsheet with around 700 figures on it. Any help would be much appreciated.

Thank you


Hi all,

I have converted a manual paper form into an excel form, and it all works fine apart from the decimal point. i basically want the amounts on the form to read like this:
456 35, which is 456.35.

I have tried using custom format cells "00000 00", but when i enter the amount using a decimal place it will change the format. I then tried using the currency format adjusted to "#,##0 . 00 ", which works, but i don't want the decimal place to be visible, is there a way of hiding it?



Hi all, hoping someone can help with the following -

i enter amounts from $1.00 to $500.00 in the range A7 to A30, although some cells can be blank, & i have the cells formatted as currency with 1 decimal point & because of limited screen space also 'shrink to fit'.

what i would like to achieve if possible is to automatically have amounts $20 formatted with no decimal point.

thanks for any help provided

I have written a simple macro for a carpenter that converts fractions of a foot (1 ich, 3 inches and so on) to decimal points. Here it is:

Sub Macro1()
Dim A As String
A = InputBox("Enter length you need converted.")
A = A * (1 / 12)
MsgBox A
End Sub

But if I enter 1, the Msgbox displays 8.3333 -2. I would like it to display .083. Can anyone tell me how that is done?

Thanks, as always.

Bill Biggs

I am trying to align my columns by decimal point. I have both negative and
positive numbers, as well as asterisks (to show statistical significance) and
so using Format|Cells|Number and trying the number, currency, and accounting
options don't seem to work, nor does the custom option when I try ##.???? or

For example, I have the following numbers I want to line up:

Any suggestions?


Format | Cells | Number and set for designed number of decimal places.
Rae Drysdale

"nastech" wrote:

> saw in xl help file, but not re-searchable. trying to align decimal points.
> other problem exists with number/text formating, e.g.: 1.5B or 1.5M
> using some workarounds:
> - distribute formatting gets rid of seeing b/m
> - cond. formatting colors represents millions or billions
> - still have mis alignement:
> 104
> 21.
> 1.0
> - Recommend MS allow use of Custom formatting "in-cell" for text / number
> strings.
> if can't already do

Is there a way to enter in dollar amounts and have the software assume a two
diget decimal point without having to actually enter in the dec. point. I
have defined the cell as currency and defined 2 dec. positions. Also defined
as accounting with 2 dec. positions. When I enter in 1234 it comes out
Any help here?

No luck finding an answer? You could always try Google.