| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To display number in text format in cells
I have a sequence of digits like
5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
To display number in text format in cells
Change the cell format to either:
Number Accounting or Currency. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Man T" wrote in message ... I have a sequence of digits like 5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
To display number in text format in cells
*OR*
Format to TEXT *before* entering (pasting) the number. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Change the cell format to either: Number Accounting or Currency. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Man T" wrote in message ... I have a sequence of digits like 5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
To display number in text format in cells
Hi,
Careful here, if you paste a number from a range onto a cell that is formatted as text the number will be stored as a number not as text, unless you tell it to paste values or paste formulas or basically you tell it to paste without formatting. -- Cheers, Shane Devenshire "RagDyer" wrote: *OR* Format to TEXT *before* entering (pasting) the number. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Change the cell format to either: Number Accounting or Currency. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Man T" wrote in message ... I have a sequence of digits like 5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
To display number in text format in cells
I'm assuming, perhaps incorrectly, that the OP is *primarily* concerned with
displaying *all* the digits. Off the top of my head, I can't immediately see a difference between the 2, except for default left or right justification. Or ... maybe not totaling with the Sum() function. Can you think of some others? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "ShaneDevenshire" wrote in message ... Hi, Careful here, if you paste a number from a range onto a cell that is formatted as text the number will be stored as a number not as text, unless you tell it to paste values or paste formulas or basically you tell it to paste without formatting. -- Cheers, Shane Devenshire "RagDyer" wrote: *OR* Format to TEXT *before* entering (pasting) the number. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Change the cell format to either: Number Accounting or Currency. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Man T" wrote in message ... I have a sequence of digits like 5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
To display number in text format in cells
Just reading him literally:
"to display as text" -- Thanks, Shane Devenshire "RagDyeR" wrote: I'm assuming, perhaps incorrectly, that the OP is *primarily* concerned with displaying *all* the digits. Off the top of my head, I can't immediately see a difference between the 2, except for default left or right justification. Or ... maybe not totaling with the Sum() function. Can you think of some others? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "ShaneDevenshire" wrote in message ... Hi, Careful here, if you paste a number from a range onto a cell that is formatted as text the number will be stored as a number not as text, unless you tell it to paste values or paste formulas or basically you tell it to paste without formatting. -- Cheers, Shane Devenshire "RagDyer" wrote: *OR* Format to TEXT *before* entering (pasting) the number. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Change the cell format to either: Number Accounting or Currency. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Man T" wrote in message ... I have a sequence of digits like 5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
To display number in text format in cells
I'm assuming, perhaps incorrectly, that the OP is *primarily* concerned
with displaying *all* the digits. Off the top of my head, I can't immediately see a difference between the 2, except for default left or right justification. Or ... maybe not totaling with the Sum() function. Yes, I just want to display the whole string of numbers as string or text but not the exponential format. The reason is the cell will contain a barcode or serial number that is all numerics. |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
To display number in text format in cells
The General format will default to scientific notation when the digits
exceed 11. Thanks for the feed-back. -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Man T" wrote in message ... I'm assuming, perhaps incorrectly, that the OP is *primarily* concerned with displaying *all* the digits. Off the top of my head, I can't immediately see a difference between the 2, except for default left or right justification. Or ... maybe not totaling with the Sum() function. Yes, I just want to display the whole string of numbers as string or text but not the exponential format. The reason is the cell will contain a barcode or serial number that is all numerics. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number display format | Excel Worksheet Functions | |||
| FormatCellsNumberText is very tricky! | Excel Worksheet Functions | |||
| Format number to display % symbol smaller than onther text in cell | Excel Discussion (Misc queries) | |||
| Number format need to display 0001 etc | Excel Discussion (Misc queries) | |||
| Excel cells should take number format and/or optional text eg Dec. | Excel Discussion (Misc queries) | |||
Linear Mode
