Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi.
I am trying to contain a number value in excel after changing the value to text. First, I calculate a cell, then change that cell from a formula to a value. Then, I want to change the value to a number with 2 digits after the decimal. My dilemma occurs when the number value shows as 3 digits after the decimal. When I try to reformat for 2 digits, the number value is displayed with 3 digits. Does that make sense? Please help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I stop Excel auto formatting the text 3-4 as 04 Apr? | Excel Discussion (Misc queries) | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
Using Excel converts number to english text | Excel Worksheet Functions | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |