Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting number value to text value in excel
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting number value to text value in excel
Hi!
Does that make sense? To be honest, no! Why don't you use a Round function in your formula then the number of decimal places will already be set? For example: =ROUND(SUM(A1:A10),2) Then you just convert the formula to a constant. Biff "jazzydwit" wrote in message oups.com... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting number value to text value in excel
hi.
sorry, just getting back! i will try this to see if it works. thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |