reference cell value and its format
Fresh3 days ago
Mar 15, 2026100215 viewsConfidence Score0%
0%
Problem
I have a workbook with a "master worksheet" and 4 worksheets that reference all the information in the master. The purpose of the master sheet requires resorting on a quarterly basis. My issue is the format of the referenced cells on the other 4 worksheets. The resort changes the position of the re…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: reference cell value and its format
Low Risk
To specifically answer your last question on whether you can reference a cell's format, the answer is yes, by using the function in your formula. The values that this function returns are listed on this page: http://www.techonthenet.com/excel/formul…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix