Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know of a way to split a decimal number????
I have found a way in a program I am writing to reference cells in a second sheets by dividing the rown number in the current sheet by 5 i.e. if the row number in the current sheet is 1 then 1/5=0.2. Therefore on the second sheet that item will be pasted on the first row (indexed by 0) and two colums accross (indexed by 2). So to come back to my question is there a way to get the right part of the decimal and left part of the decimal. So that: index accross = decimal value index down = whole number I have thought about the left function however this will go upto 1000 entries (therefore left,4 = 0.2) so this will not work :( Thanks in advance, Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Split a decimal figure | Excel Discussion (Misc queries) | |||
How to split numbers and decimal in 2 columns | New Users to Excel | |||
Split number with decimal places into 2 columns | New Users to Excel | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
how to split one decimal pt integer off & to next columnin excel? | Excel Discussion (Misc queries) |