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?

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?