| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split a decimal figure
On Tue, 26 Aug 2008 22:00:10 -0400, "Rick Rothstein \(MVP - VB\)"
wrote: I have a figure in A1. For example, 255.875 Is it possible to bring 255 in B1 and 875 in C1 as numbers, not text? What do you want to show, in C1, if A1: 255.012 Great question! Jaleel... just so you don't miss the point, Ron is asking about 255.012 in comparison to 255.12 (or even 255.0012). Rick Thanks for clarifying the point I was trying to make, Rick. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal figure to minutes and seconds | 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) | |||
Hybrid Mode
