Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mz mz is offline
external usenet poster
 
Posts: 40
Default References omit formatting and return cell address - not data


In two cases of references between worksheets, the formatting from the
original cell does not appear in the cell that it is referenced to.

Case 1:
Worksheet 1, A1 contains a currency formatted number - $2,000
Worksheet 2, A1 references the Workhseet 1, A1 cell using the = sign, yet it
returns 2000 (unless I manually reformat the Workksheet 2 cell to Currency


Case 2:
Worksheet 3, A1 contains an apartment # - e.g. 4
Worksheet 4, A1 references this cell but returns the cell address -
Worksheet2,!A1' - rather than the number 4. I tried different formats for the
number 4, including =TEXT, but it did not correct the problem.

Thank you
--
MZ
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 96
Default References omit formatting and return cell address - not data

Case 1
Sheets 1 & 2 in col a will have to be formatted as currency but you only
need do this the once.

Case 2
Check your inputs.

"MZ" wrote:


In two cases of references between worksheets, the formatting from the
original cell does not appear in the cell that it is referenced to.

Case 1:
Worksheet 1, A1 contains a currency formatted number - $2,000
Worksheet 2, A1 references the Workhseet 1, A1 cell using the = sign, yet it
returns 2000 (unless I manually reformat the Workksheet 2 cell to Currency


Case 2:
Worksheet 3, A1 contains an apartment # - e.g. 4
Worksheet 4, A1 references this cell but returns the cell address -
Worksheet2,!A1' - rather than the number 4. I tried different formats for the
number 4, including =TEXT, but it did not correct the problem.

Thank you
--
MZ

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return the Cell address of a value Jack_442 Excel Worksheet Functions 3 September 12th 09 03:55 AM
Return a cell address Frank Pytel Excel Worksheet Functions 5 October 31st 08 01:19 PM
return multiple cell references laszlo Excel Discussion (Misc queries) 4 September 6th 07 10:54 PM
External cell references using INDIRECT & ADDRESS Conan Kelly Excel Worksheet Functions 1 December 28th 06 07:05 PM
Return Cell References Craig Excel Worksheet Functions 1 February 17th 05 03:32 AM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"