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.

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.

- Change decimal point in regional options
- Deleting numbers after decimal point
- Decimal format with no trailing zero and also no trailing decimal point
- Change Default Decimal Points For Numbers
- Disapearing zero after decimal point
- Inserting decimal point
- Return Nth Value To Right Of Decimal Point
- Removing Decimal Points From A Number
- Optional Decimal Points In Cell Format
- Reducing Decimal Points without Rounding up the Numbers
- Inserting decimal point
- Decimal points
- Formulas : Decimal Points
- HELP!!!! Decimal Point Problem in VBA txtbox input form
- Assumed decimal point
- Format to bring decimal point forward
- Change decimal point on a result
- Mail merging from excel (decimal points)
- Hiding decimal point
- Decimal point formatting
- Need to eliminate scientific display of decimal point
- Aligning by decimal point - negative and positive numbers
- ALL NUMBERS I TYPE HAVE DECIMAL POINT
- Can not find align decimal points option
- Defined cell as currency but still have to enter decimal point

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

VB:and it is referred as read-only!Application.International(xlDecimalSeperator)If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Thank you in advance for your time and suggestions!

Athina

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

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.

http://www.ozgrid.com/forum/showthread.php?t=129919

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,

Joel

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

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.

What I'm looking for is:

1231.5 = 12315

123.15 = 12315

12.315 = 12315

1.2315 = 12315

Can anyone help ?

Thanks in advance

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:

12.5%

13.6%

11.0%

14.4%

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:

12.5%

13.6%

11%

14.4%

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,

Jordan

Is there a simple way to do this?

Thanks,

Ignorant in Despair

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

637400

450000

528080

1051200

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

6374.00

4500.00

5280.80

10512.00

in a few easy clicks?

Thanks in advance.

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 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!

Examples:

417.93 would show as 000000041793000

and

3,576.18 would show as 000000357618000

Thanks for any help.

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

Thanks!

Thank you

Sam

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?

Cheers

Ryan

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

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

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:

-0.2684***

-0.2602***

0.7165**

1.0023

Any suggestions?

OF MY NUMBERS ANDIN SOME CASES ARE ROUNDING UP .

--

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

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

1,234.00.

Any help here?

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