Home |
Search |
Today's Posts |
#1
|
|||
|
|||
custom a cell
How do make that when I enter 1234 its should come out 12.34 -- shlomo ------------------------------------------------------------------------ shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304 View this thread: http://www.excelforum.com/showthread...hreadid=346808 |
#2
|
|||
|
|||
Format Cell Number change decimal and symbol -- Cissy ------------------------------------------------------------------------ Cissy's Profile: http://www.excelforum.com/member.php...o&userid=20107 View this thread: http://www.excelforum.com/showthread...hreadid=346808 |
#3
|
|||
|
|||
Right click cell, select 'Format Cell' and select 'number'
"shlomo" wrote: How do make that when I enter 1234 its should come out 12.34 -- shlomo ------------------------------------------------------------------------ shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304 View this thread: http://www.excelforum.com/showthread...hreadid=346808 |
#4
|
|||
|
|||
Easiest way would be to go to ToolsOptionsEdit and checkmark "fixed deimal
places" and set to 2. Otherwise divide 1234 by 100 after the fact. Enter 100 in an empty cell then Copy that cell. Select the other cell with 1234 and Paste SpecialDivideOKEsc. Others have posted that you can change 1234 into 12.34 by formatting. You would still have 1234 as a value no matter how you format it. Gord Dibben Excel MVP On Fri, 18 Feb 2005 10:30:16 -0600, shlomo wrote: How do make that when I enter 1234 its should come out 12.34 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom format a text cell with square brackets: [ ] ? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |