formula problem

nancyo · Apr 10th, 2002, 01:26 PM

I am trying to refer to another spreadsheet in a cell (i.e. ='Sheet1'!A1). The cell I am refering to is formatted as text - I am entering a number as 055, and need it to be 055 and not 55.

When I enter the formula into the cell, most of the time this works. However, sometimes it does not work, and refers to the formula rather than the value. So, I am seeing the actual sheet reference and not the value 055.

The cell with the formula is NOT formatted as text.

Any suggestions? This should not be hard at all...and is driving me crazy.

Mark W. · Apr 10th, 2002, 01:30 PM

Quote:

On 2002-04-10 12:26, nancyo wrote:
The cell I am refering to is formatted as text - I am entering a number as 055, and need it to be 055 and not 55.

I'm not convinced. Are you sure it's formatted as Text?

nancyo · Apr 10th, 2002, 02:04 PM

Yes, it is formatted as test. I think this is a glitch. I have another spreadsheet that I am using which is identical, and it works fine.

Dave Hawley · Apr 10th, 2002, 09:06 PM

Hi nancyo

If you reference a cell that has been formated as Text it is very likely that the formula cell would also take on a Text format! If you would like to see leading zero's in a number use the Custom Format: 000 Just add/take zeros as needed.

nancyo · Apr 11th, 2002, 06:01 AM

Dave - Thanks!!! It worked. Sometimes it's the simple things that make my day!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 01:26 PM	#1
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I am trying to refer to another spreadsheet in a cell (i.e. ='Sheet1'!A1). The cell I am refering to is formatted as text - I am entering a number as 055, and need it to be 055 and not 55. When I enter the formula into the cell, most of the time this works. However, sometimes it does not work, and refers to the formula rather than the value. So, I am seeing the actual sheet reference and not the value 055. The cell with the formula is NOT formatted as text. Any suggestions? This should not be hard at all...and is driving me crazy.

Apr 10th, 2002, 02:04 PM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	Yes, it is formatted as test. I think this is a glitch. I have another spreadsheet that I am using which is identical, and it works fine.

Apr 10th, 2002, 09:06 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi nancyo If you reference a cell that has been formated as Text it is very likely that the formula cell would also take on a Text format! If you would like to see leading zero's in a number use the Custom Format: 000 Just add/take zeros as needed.

Apr 11th, 2002, 06:01 AM	#5
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	Dave - Thanks!!! It worked. Sometimes it's the simple things that make my day!