A
Aubrey
When doing a merge of text (or numbers) (such as a street number cells with
street name cells) the fraction-format numbers are reduced to decimal
numbers. It would be very helpful if number formats could be retained after
a merge, and/or fraction type numbers be allowed to be paste-special as text
and therefore retained after a merge in fraction format. We deal with pole
mounted electrical service addresses that all end in a 1/2. The current
limitation prevents address sorting and we hope this feature can be added
soon.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
street name cells) the fraction-format numbers are reduced to decimal
numbers. It would be very helpful if number formats could be retained after
a merge, and/or fraction type numbers be allowed to be paste-special as text
and therefore retained after a merge in fraction format. We deal with pole
mounted electrical service addresses that all end in a 1/2. The current
limitation prevents address sorting and we hope this feature can be added
soon.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions