Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter 5 in 1 cell, show first 3 in other cell
I want to be able to:
enter a 5 digit number into in cell a1 have the first 3 digits appear in cell a2 Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter 5 in 1 cell, show first 3 in other cell
A round about way would be to have it multiply by .01 and then either
convert it to a integer or just have it not show decimals "JcR" wrote in message ... I want to be able to: enter a 5 digit number into in cell a1 have the first 3 digits appear in cell a2 Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter 5 in 1 cell, show first 3 in other cell
Ryan,
Thanks, good thought but not applicable. I would be entering a 5 digit zipcode in cell a1, and want the first three digits to appear in cell a2 Let me know if you can think of anything. "Ryan Jones" wrote: A round about way would be to have it multiply by .01 and then either convert it to a integer or just have it not show decimals "JcR" wrote in message ... I want to be able to: enter a 5 digit number into in cell a1 have the first 3 digits appear in cell a2 Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter 5 in 1 cell, show first 3 in other cell
=INT(A1*0.01)
This makes value in a1 go into cell with only first 3 "JcR" wrote in message ... Ryan, Thanks, good thought but not applicable. I would be entering a 5 digit zipcode in cell a1, and want the first three digits to appear in cell a2 Let me know if you can think of anything. "Ryan Jones" wrote: A round about way would be to have it multiply by .01 and then either convert it to a integer or just have it not show decimals "JcR" wrote in message ... I want to be able to: enter a 5 digit number into in cell a1 have the first 3 digits appear in cell a2 Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter 5 in 1 cell, show first 3 in other cell
"JcR" wrote in message
... I want to be able to: enter a 5 digit number into in cell a1 have the first 3 digits appear in cell a2 =LEFT(A1,3) -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine a cell's width and enter it in the cell | Excel Discussion (Misc queries) | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
for the experts | Excel Discussion (Misc queries) | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |