|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 23rd 08, 05:31 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
cell format text and data displayed like a number
I would like to have the cell format set as text but display numbers
like $123,456.1234 while still having the data be just 123456.1234 I know that it would be easier to set the cell format to number, but I want to manipulate the data and the number format messes that up. I can start out with the cell format set at text, manipulate the data, and -then- set the cell format to number to get the proper display, which works fine until the user enters a number in that cell a second time and now the format is set to number. 
|
| Ads |
|
#2
March 23rd 08, 07:16 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell format text and data displayed like a number
Use Format>Cells>Custom then in the box above the suggested custom styles
type: "$###,##0.0000_"; ($###,##0.0000) Then click OK "RC" wrote: > I would like to have the cell format set as text but display numbers > like $123,456.1234 while still having the data be just 123456.1234 > I know that it would be easier to set the cell format to number, but I > want to manipulate the data and the number format messes that up. I > can start out with the cell format set at text, manipulate the data, > and -then- set the cell format to number to get the proper display, > which works fine until the user enters a number in that cell a second > time and now the format is set to number. >
|
|
#3
March 23rd 08, 07:17 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell format text and data displayed like a number
Or, just select currency and set the decimal places to 4.
"RC" wrote: > I would like to have the cell format set as text but display numbers > like $123,456.1234 while still having the data be just 123456.1234 > I know that it would be easier to set the cell format to number, but I > want to manipulate the data and the number format messes that up. I > can start out with the cell format set at text, manipulate the data, > and -then- set the cell format to number to get the proper display, > which works fine until the user enters a number in that cell a second > time and now the format is set to number. >
|
|
#4
March 24th 08, 03:14 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell format text and data displayed like a number
On Mar 23, 2:17 pm, JLGWhiz > wrote:
> Or, just select currency and set the decimal places to 4. > > "RC" wrote: > > I would like to have the cell format set as text but display numbers > > like $123,456.1234 while still having the data be just 123456.1234 > > I know that it would be easier to set the cell format to number, but I > > want to manipulate the data and the number format messes that up. I > > can start out with the cell format set at text, manipulate the data, > > and -then- set the cell format to number to get the proper display, > > which works fine until the user enters a number in that cell a second > > time and now the format is set to number. Thanks, I will try both of the above suggestions, it looks like they don't mess up the data, so I can still manipulate the numbers as a 'text' string.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I format a cell to have the same text with a number | kpt | Excel Worksheet Functions | 2 | August 5th 08 12:55 PM |
| how do i format the text displayed in a drop down menu? | BMA | Excel Discussion (Misc queries) | 1 | March 20th 07 11:41 AM |
| Count number of times a specific number is displayed in a cell ran | subs | Excel Worksheet Functions | 1 | June 27th 05 05:01 PM |
| Displayed number format | Kevin | Excel Worksheet Functions | 2 | November 23rd 04 04:23 PM |
| data imported into EXCEL as text displayed as exponential number | Irv Whalley | Excel Programming | 0 | April 5th 04 02:41 PM |
Linear Mode
