| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
excel is always formatted as text when opened
a colleague emails me a spreadsheet once a month and the numbers are always
in text format. She manually adds both text and numbers in different columns but has always had that problem with her excel........I can not find anything on how to fix it othere then to change the format to General everytime I get it. Is her excel set up weird? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
excel is always formatted as text when opened
Sounds like she has pre-formatted all cells as Text before entering the
data. Gord Dibben MS Excel MVP On Mon, 21 Jul 2008 09:43:00 -0700, laidebug wrote: a colleague emails me a spreadsheet once a month and the numbers are always in text format. She manually adds both text and numbers in different columns but has always had that problem with her excel........I can not find anything on how to fix it othere then to change the format to General everytime I get it. Is her excel set up weird? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Excel: text in cell becomes hidden when formatted to wrap tex | Excel Discussion (Misc queries) | |||
| Excel color-formatted text previews & prints in black | Excel Discussion (Misc queries) | |||
| How to count the number of Excel cells with text formatted Italic | Excel Worksheet Functions | |||
| In Excel formatted wrapped text displays as xxx in cell | Excel Discussion (Misc queries) | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Linear Mode
